Skip to content

Working days between two dates

Count Monday to Friday between two dates, optionally skipping holidays.

The formula

Argument separator
Excel and Google Sheets
=NETWORKDAYS(A2, B2, Holidays!$A$2:$A$20)

How it works

  1. A2, B2

    Start and end dates. Both days are included.

  2. Holidays!$A$2:$A$20

    Optional list of holiday dates to skip. Leave it out if you have none.

Example

A: StartB: EndC: Result
2026-03-02 (Mon)2026-03-06 (Fri)5
2026-03-02 (Mon)2026-03-13 (Fri)10

Tips

  • For weekends other than Saturday and Sunday, use NETWORKDAYS.INTL.