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

Polaris Training in Classic Workspace.
Hi, I currently don't have access to the Anaplan Polaris workspace. Is it acceptable to proceed with the training in the classic workspace, or will this create issues later and prevent me from obtaining Polaris certification? Let me know if you have any insight on this.
I need to flow data from a model DAT01a in PBF Dev to PBF Consol
I need to flow data from a model DAT01a in PBF Dev to PBF Consol, we use connectors to do this OUT3A and OUT3B Any instructions or tips on how to build or test the data can be flowed through to PBF Consol?
User story 3.3 To derive Monthly Commission Forecast
Hi, My values of monthly commission forecast is not matching the Check your build values. Please help to identify where I am wrong. As I have attached screenshots of the blueprint and module grid view. Thanks, Sre Varshaa S