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.

rishi8118

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

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Importing from Data Hub: Incorrect or Missing Mappings in Target Model
When importing data from a Data Hub to another model, I'm seeing values in the target model that don't exist in the source. For example, seller assignments are being tagged with subregions that aren't present in the source data - some assignments are missing expected tags, while others are mapped to seemingly random…
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…