Number of working days in a month

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

Call Center Indodax
Hubungi Call Center INDODAX melalui +62822225789 WA atau email support@indodax.com.
How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…