Count Working Days Between Two Dates
“Count the working days between two date columns”
Count the working days between two dates, both ends included, and write the number to a number column. Weekends, public holidays and company time off are excluded.
Use Cases
Show the real working-day length of every task, not calendar days
Measure how many working days a request took from open to close
Feed working-day counts into formulas and dashboards for capacity planning
Real-World Example
A project runs from 22 December to 2 January. Calendar days say 12; this action writes 6 to a 'Working Days' number column in the UK once weekends, Christmas Day, the Boxing Day substitute holiday and New Year's Day are excluded, and fewer still if you add company closure days.
Ready to use this recipe?
Get Community Cookbook from the monday.com marketplace and unlock every custom trigger and action. Always $10/month — the recipe list keeps growing but the price never goes up.