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

Kev

Accepted answers

All comments

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

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

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

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

Hope this helps

kevinsanghoi

Hi @DeveloperCYT ,

It works !!

Thanks.

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…