SheetsLessons
Lesson 42 · Dates & Times

NETWORKDAYS & WORKDAY

Practise NETWORKDAYS and WORKDAY in Google Sheets: count business days between dates and find delivery dates, skipping weekends and a list of holidays.

Task 1 of 4

How many working days (Mon to Fri) does the first project span, counting the start and end days? Answer in D2.

D2
fx

Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.

Counting business days

  • =NETWORKDAYS(start_date, end_date, [holidays]) counts the Monday-to-Friday days between two dates, including both ends, and leaves out any dates in the holidays range.
  • =WORKDAY(start_date, num_days, [holidays]) goes the other way: it returns the date that is num_days business days after the start (or before, if negative), skipping weekends and holidays.

Keep public holidays in their own column and point the third argument at it, such as F2:F6. Lock it with $F$2:$F$6 if you copy the formula down.

Watch out for

  • NETWORKDAYS counts the start day. Monday to Friday of the same week is 5, not 4.
  • If the end is before the start, NETWORKDAYS gives a negative number.
  • Both functions assume Saturday and Sunday are the weekend. For a different weekend, Sheets has NETWORKDAYS.INTL and WORKDAY.INTL.