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

Kayla

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

Paul Newcome

Try something like this...

Months:

=INT([Duration Days]@row / 30)

Weeks:

=INT(([Duration Days]@row - ([email protected]* 30)) / 7)

Days:

=[Duration Days]@row - (([email protected]* 7) + ([email protected]* 30))

Paul Newcome

Try something like this...

Months:

=INT([Duration Days]@row / 30)

Weeks:

=INT(([Duration Days]@row - ([email protected]* 30)) / 7)

Days:

=[Duration Days]@row - (([email protected]* 7) + ([email protected]* 30))

Kayla

As usual, Paul is a genius.

Paul Newcome

Happy to help.️