Convert Days to Year, month

Lisbeth Fuentes-Fernandez

Hi I am using this Formula =(TODAY() - DATEONLY([Appointment Start Date]2)) to give be days from a date started to today. The answer gives me a whole number eg 830 Days.

How can I convert the days to Years, month while still using the above formula??

Paul Newcome

Do you mean an output such as

"2 Years 3.3 Months"

?

Liz P

I have a Joining Date and am trying to create a Years of Service in Years and Months and I get as far as having this displayed in number of months but I would like this to display as "8 years, 8 months" for example. If the [Joining Date] is 01/01/14 for the figure today that is -1/09/22 - the number that returns is 104 - which is number of months.

Paul Newcome

If you already have the number of months then you would use something like this:

=ROUNDDOWN([Number Of Months]@row / 12) + "" + " Years" + MOD([Number Of Months]@row, 12) + "" + " Months"