Working Days Calculation

Hi, I have been using the long formula for working days suggested in the Anaplan help, and it's been giving me some issues, so I created a new one

It's shorter and easier to follow and thought I would share


You need 5 fields*



*Holidays is optional and can be removed


example of calcs


Hope it helps





  • Nice @DeveloperCYT thanks for sharing this. These types of calculations are crucial for daily use cases that have a weekly cadence like a service desk. I recently had to use something like this to determine hours of operation. Nice!