1. Calculation functions
  2. Functions
  3. Excel equivalent formulas
  4. NETWORKDAYS

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