Register

Working Days Calculation

DeveloperCYT
Regular Contributor

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*

workdays1.PNG  

wdcalc.PNG

*Holidays is optional and can be removed

 

example of calcs
netdays.PNG

 

Hope it helps

 

Kev

 

1 REPLY 1
JaredDolich
Moderator

Re: Working Days Calculation

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!


Jared Dolich