Discussions

 View Only
  • 1.  Work weeks for a project duration

    Posted 07-17-2019 16:43
    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?


  • 2.  RE: Work weeks for a project duration

    Posted 07-17-2019 17:30
    Using the Ceil function should address your needs.

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



  • 3.  RE: Work weeks for a project duration

    Posted 07-17-2019 17:45
    Thanks, Diana!  Should I change the field type from Duration to Formula-Numeric?


  • 4.  RE: Work weeks for a project duration

    Posted 07-17-2019 19:06
    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.