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.
Page 1 / 1
Hello
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
Reply
Planview Customer Community
Already have an account? Login
Planview Customer Community
No account yet? Create an account
Login with SSO
Login with Planview Adminor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
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
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