How to convert Days into Months and Days?

Originally Posted by arthurbr

Datedif used with startdate 0 does provide for problems because XL assumes incorrectly that 1900 is a leap year

The question is : what do you call a year? If 1 year = 365 days, =quotient(A1,365)&" years" will give the whole number of years
Which result do you need ? Please provide an example?

The purpose of this is to determine the length of service. I agree with daddylonglegs that by using quotient, it would mean all months are equal (ie. 30 days), which is not true. This would mean that 365 days would return 12 months 5 days.

I did try to use quotient (A1, 365) followed by Mod(A1,30) but this doesn't seem to return the right figure. I am using 400 days as example, it will return 1 and 10, which I find it not reflective. Any thoughts how to improve further?