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
- Using the Ceil function should address your needs.
Example:
Ceil(ToDays([End Date]-[Start Date])/7) - Thanks, Diana! Should I change the field type from Duration to Formula-Numeric?
- 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.
