You can recreate the effect of the Excel NETWORKDAYS function in Anaplan.

The Excel NETWORKDAYS function returns the number of whole working days between a start and end date.

To recreate the NETWORKDAYS function in Anaplan:

1. Create three source line items.
1. A Date data type line item for the start date, Start date.
2. A Date data type line item for the end date, End date.
3. A Number data type line item for the number of holiday days, Holidays.
2. Create a line item that contains the following formula, which recreates the NETWORKDAYS function:

IF ISBLANK(End Date) THEN 0 ELSE (End Date - Start Date + 1 - (8 - WEEKDAY(Start Date)) - WEEKDAY(End Date)) / 7 * 5 + (IF WEEKDAY(Start Date) > 5 THEN IF WEEKDAY(End Date) > 5 THEN 5 ELSE WEEKDAY(End Date) ELSE 6 - WEEKDAY(Start Date) + IF WEEKDAY(End Date) > 5 THEN 5 ELSE WEEKDAY(End Date)) - Holidays

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.