Convert Days to Year, month
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??
Answers
-
-
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.
-
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"
Help Article Resources
Categories
Check out the Formula Handbook template!