FormulaCraft

NETWORKDAYS

NETWORKDAYS counts the whole working days between a start and end date, skipping Saturdays and Sundays. Pass a holiday range as a third argument to skip those too.

Excel
=NETWORKDAYS(A2, B2)
Google Sheets
=NETWORKDAYS(A2, B2)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2 is the start date and B2 the end date.
  2. 2Weekends are excluded automatically.
  3. 3Add a third argument with a holiday range to exclude holidays.

Need a version for your data?

Try: “Count the working days between the dates in A2 and B2”

Related

TODAY / DATEDIFEOMONTHWEEKDAY

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: