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
-
Do you mean an output such as
"2 Years 3.3 Months"
?
-
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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!