Formula to show duration days in Months, Weeks, and Days
I have a duration in days column and I need to show what that duration is in months, weeks and days. Assuming a month is 30 days and a week is 7 days.
The attached blue columns are what I want to calculate with a formula (manually entered now to show what I want to see).
For example, if something is 38 days, I want it to show 1 month, 1 week, and 1 day.
Hopefully someone can help!
This was the closest post I could find in the community, but they days is not showing accurate for me. https://community.smartsheet.com/discussion/90560/convert-count-of-days-to-months
Help Article Resources
Check out the Formula Handbook template!