Wauvel

Excel like a finance pro.

← The library

Date function

NETWORKDAYS

Counts working days between two dates, skipping weekends and listed holidays.

Very commonDifficulty 1150 · ProficientUsage rank #74 of 520
Practice · 22 questions →

When to use it

Working days between two dates, inclusive, skipping Saturdays, Sundays, and any holidays you list. Turnaround times and SLAs.

The shape of it

Syntax
=NETWORKDAYS(start_date, end_date, [holidays])

Worked examples

  • Two weeks

    =NETWORKDAYS(DATE(2025,3,3),DATE(2025,3,14)) → 10

    Monday March 3 through Friday March 14: two full weeks.

  • With a holiday

    =NETWORKDAYS(DATE(2025,3,3),DATE(2025,3,14),DATE(2025,3,7)) → 9

    With March 7 as a holiday.

  • Holiday list

    =NETWORKDAYS(A2,B2,Holidays) → 18

    Holidays as a named range of dates.

Worth knowing

  • Both ends count, so a Monday-to-Monday span is 6, not 5.
  • Keep a Holidays sheet and name the range.
  • NETWORKDAYS.INTL for non-standard weekends.

Where it goes wrong

  • Text dates in the holiday list are ignored silently.
  • Negative when the end date is before the start date.

Related

TODAYDATEMONTHYEARNOWDAY

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.