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:

Answers

  • 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!

  • kevinsanghoi
    kevinsanghoi

    Hi @DeveloperCYT, Thanks for sharing this but there are a few scenarios where the weekend days calculations is missing a day.

    For Example, If my start date is 1st April 2023 and End Date is 30th April then I get the result for weekend days as 9 but there are 10 weekends in April. Is there any way where the calculations can get more accurate.

    Thanks !

  • DeveloperCYT
    DeveloperCYT

    Hi, thanks i had not spotted that, and now i have updated to new version, which is correct

    image.png

    Added 2 parts to calculate the number of Saturdays and Sundays between the 2 dates and add them up

    image.png
    image.png

    Hope this helps

  • kevinsanghoi
    kevinsanghoi

    Hi @DeveloperCYT ,

    It works !!

    Thanks.

Categories