nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Number of working days in a month

PrevContributor

Excel uses the formula function NETWORKINGDAYS to calculate the number of working days in a month How would I do this in Anaplan? Link to an input module?

Accepted answers

PrevContributor

Hello Jonathan,

Anaplan does not currently have a similar function, but you could use an assumption module to collect the number of working days in a month or to "flag" days as working days and then get a monthly total of working days.

Heather

All comments

PrevContributor

Thanks for that,

The module can hold the actual working days in the month, although it will be a tedious task calculate the working days in excel for each contractor and load them on a regular basis. How do others build a contractor based model? Is it likely this will be a feature built in time?

PrevContributor

Hi Heather,

Has this feature been added? I see that this thread was from a few years ago.

Thanks,

Lara

leo_tadjudin_1

Hi Lara,

I don't think there are any changes to the formula addressing working days in a month. You could always use WEEKDAY formula and Holiday mapping (dependent to year and region) to address this.
I have attached a sample screens below in which I used to address number of working days in a month.

Hope that helps.

Thanks,

Leo

michel_maurel

Hi,using the weekday formula in addition to a dedicated time management module will make the job :

weekday will allow you to split days monday to sunday, thus having the "usual" working days easely indentified.

a time management module with boolean will allow you to add January 1st, Xmas day and and so on either manually or through formulas by testing dates (01/01, 25/12....) depending on your country.
Kind regards.

Michel.

rishikesh.shukla

There's no direct function as NETWORKINGDAYS or anything similar to it but the same can be achieved using the below method.

Create a module. For Ex: Working Days Filter
Working Days have a time Scale as Days.
Line Item: Days, WeekDays, Holiday, Working Week Days, and Worked on Weekdays.
1. Days: Format- Date, Formula: START()
2. WeekDays: Format-Number, Formula: WEEKDAY(Days)
3. Holiday: Format-Boolean, Manual Input
Working Week Days: NOT (WEEKDAY(Days) = 6 OR WEEKDAY(Days) = 7 OR Holidays)

Quick Links

Can you help?

Unanswered questions

Anaplan XL Forms Error
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
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.…