Work weeks for a project duration

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • In Progress
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?
Photo of Amanda Baker

Amanda Baker

  • 82 Points 75 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Using the Ceil function should address your needs.

Example:
Ceil(ToDays([End Date]-[Start Date])/7)

Photo of Amanda Baker

Amanda Baker

  • 82 Points 75 badge 2x thumb
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.