# How to show/convert days to weeks on project plan

Options
✭✭✭✭✭

Hello All,

duration column circled in blue is automated as per the project setting

circled in red is all manual

I know weeks cant be determined from entering dates so i entered weeks manually in actual duration column and it has set the dates, but the roll up is in days

is there a formula I can use on another column to calculate the number of weeks and days to capture all this separately please? I need to calculate this for the target as well actual so i can measure the different in duration.

Any help would be appreciative

@Paul Newcome @Genevieve P. tagging you guys as always as you have been helpful to me in the past.

if anyone knows the answer please feel free to comment, i would really appreciate it.

I need this urgently please, thank you in advance!

Tags:

## Answers

• ✭✭✭✭✭
Options

Hey @Maz Uddin,

If you want the Actual Duration column in the Parent row to show the # of weeks, you could use this in that cell:

=INT(SUM(CHILDREN()) / 7) + "w"

Hope this helps!

If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!

I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!

• ✭✭✭✭✭✭
Options

Try something like this in the top row:

=INT([Actual Duration]@row / 5) + "w " + MOD([Actual Duration]@row, 5) + "d"

The Target would be the similar with the exception of changing both 5s to 7s. Since those are manually entered, they are not automatically accounting for working days like the project settings columns are.

• ✭✭✭✭✭
Options

when i do this formula i get #INVALID OPERATION

• ✭✭✭✭✭✭
Options

Ok. Try this instead then:

=INT(NETWORKDAYS([Actual Start Date]@row, [Actual End Date]@row) / 5) + "w " + MOD(NETWORKDAYS([Actual Start Date]@row, [Actual End Date]@row), 5) + "d"

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!