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

Reverse Lookup for a List to List Mapping (more than one mapping)
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
Connection Problem with Excel Add-In Series 4 - No Customer
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
explainability results is blank into model
Why in my model output is blank, after send explainability data.