Formula to show duration days in Months, Weeks, and Days

Kayla ✭✭✭✭✭
edited 07/20/23 in Formulas and Functions

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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!