Get instant live expert help on I need help with months to years

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi, I want to make formula for showing no. Service Slab Benefit For Service < 31 years 1 month basic salary for each year of service with a cap of 15 months salary. For Service >= 31 years 15 months salary + half month salary for each additional years of service above 30 years.
Solved by K. Y. in 14 mins
i need formula for gratuity of total years which satisfying below conditions. Condition: Min 4 years 6 months and 1 day if this condition is true then total years becomes 5 years.
Solved by O. E. in 25 mins
Can you convert actual days of the work for the years to months or weeks
Solved by D. F. in 14 mins
I finished an amortization table excel for my excel class. The 2nd part of the question asks us to figure out the number of years and months that 1/4 of the loan is paid off, the number of years and months that 1/2 of the loan is paid off, the number of years and months that 3/4 of the loan is paid off, and the year and month when the payment is equally split between interest and principal.
Solved by M. E. in 11 mins
I tried to convert a value into date but excel gave me a unique string referencing months and years instead.
Solved by V. B. in 19 mins