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)
Example:
Ceil(ToDays([End Date]-[Start Date])/7)