Working Days Calculation

DeveloperCYT
DeveloperCYT
in Modeling

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

 

Tagged:

Comments

  • JaredDolich
    JaredDolich

    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!

Categories