Work weeks for a project duration
I need a field to display total number of work weeks associated with a project duration. For instance, if a project starts 7/17/19 and completes 8/1/19 it "touches" 3 work weeks. Can anyone help?
Forum Discussion
For a Duration formula field type, you can use
Weeks(Ceil(ToDays([End Date]-[Start Date])/7))
In the field properties, set the Value Display to Weeks instead of Smart Units or any other option.
Weeks(Ceil(ToDays([End Date]-[Start Date])/7))
In the field properties, set the Value Display to Weeks instead of Smart Units or any other option.