Skip to main content
Question

Workflow rule to calculate business days

  • August 4, 2025
  • 1 reply
  • 31 views
J
Planview Partner
Forum|alt.badge.img

Workflow rule to calculate business days
Best regards, could you please help me with a function that can calculate the business days between the start and end dates of an activity, excluding Saturdays, Sundays, and holidays.
Thank you.

    This topic has been closed for replies.

    1 reply

    Aayush
    Planview Falcons
    Forum|alt.badge.img+4
    • Aayush
    • Community Manager
    • August 6, 2025

    Hello ​@JUAN PABLO - 
     

    You can calculate business days between two dates (excluding Saturdays, Sundays, and holidays) using a formula or function in your workflow. The relevant function is Days(), which can take an optional parameter to return only working days:

    • Use Days(Number, TRUE) to return only working (business) days.
    • You may need to integrate organization calendar settings to also exclude public holidays.

    If you need further customization (like integrating a specific holiday list), it may require a custom field or more advanced workflow formula—please consult your AM or support for specific implementation.


    https://success.planview.com/Planview_AdaptiveWork/Reporting/Reports%2C_Functions%2C_and_Relation_Tables/AdaptiveWork_Functions/Date_Functions/Days_Function

    https://success.planview.com/Planview_AdaptiveWork/Reporting/Reports%2C_Functions%2C_and_Relation_Tables/AdaptiveWork_Functions/Date_Functions/DateSubtract_Function

    J
    Terms of UseCookie settingsAccessibility statement
    All Data Subject Access Requests (DSARs), and requests of “Do Not Sell My Personal Information” according to the CCPA, must be submitted through the Planview DSAR portal located here

    Planview has appointed a Data Privacy Officer (DPO) to be responsible for overseeing our Privacy Management Program and related privacy compliance measures. DPO can be contacted at privacy@planview.com