Working Days Calendar & Date Difference Calculation
S
Sarah .
It would be extremely useful to have the option to define a working days calendar (e.g. Monday–Friday, excluding weekends and optionally holidays) that can be used across the system.
This calendar should also be supported by the DATEDIFF formula, allowing users to calculate the number of working days between two dates instead of calendar days. This would greatly improve scheduling, deadline tracking, project management, and KPI reporting for businesses that operate on working days rather than calendar days.
A
AlexM
I believe this exists? Workplace Administration -> General -> Workspace Profile -> Working Days. Then, the WORKDAYS_DIFF function takes this into account if you want to use this in a formula field. I use this function to determine a project's turnaround, accounting for workdays.
S
Sarah .
AlexM
Thanks for the feedback! I have since discovered this formula field workaround, which has solved a couple of my queries.
However I meant for the work days to be a general rule across all date functions in the workspace. Most important is for this to be effective when automating due dates to be '3 days later' and so on...