formula for a project to determine the #weeks based on the Project completion date

System

This discussion was created from comments split from: Welcome to the online Smartsheet Community!.

Jacqui

Hello

I'd love to know what would be the best formula for a project to determine the #weeks based on the Project completion date and go backwards from there.

For example 9/8 is the Project due date, so this would be week 0, then the previous task will follow under wk 1 and so on. This will be dependent on the dates constraints obviously, so there might be a few tasks under wk1.

If anyone has any insights it would be greatly appreciated.

Here is one example I found https://community.smartsheet.com/discussion/75456/weeks-to-project-due, but I need the due date to be reflected as week 0 ;)

Many thanks,

Paul Newcome

Are you able to provide a screenshot of your sheet for reference? We should be able to subtract the due date on that row from the max due date and then divide by seven. The ROUNDDOWN function should get what you need.

=ROUNDDOWN((MAX([Due Date]:[Due Date]) - [Due Date]@row) / 7)