Skip to main content
Question

Work weeks for a project duration

  • July 17, 2019
  • 0 replies
  • 22 views
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?
    This topic has been closed for replies.

    Forum|alt.badge.img
    • DianaMiller
    • Quickbase Alumni
    • July 17, 2019
    Using the Ceil function should address your needs.

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

    • AmandaBaker
    • Author
    • Quickbase Alumni
    • July 17, 2019
    Thanks, Diana!  Should I change the field type from Duration to Formula-Numeric?
    Forum|alt.badge.img
    • DianaMiller
    • Quickbase Alumni
    • July 17, 2019
    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.
    Terms & ConditionsAccessibility statement