Spreadsheet formulas explained, side by side

NETWORKDAYS Function in Excel, Google Sheets, Airtable & Notion

NETWORKDAYS counts the working days from a start date to an end date, including both, skipping Saturdays, Sundays and any holidays you list.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inNETWORKDAYS(start_date, end_date, [holidays])
NETWORKDAYS.INTL lets you choose other weekend days.
Google Sheets✔ Built inNETWORKDAYS(start_date, end_date, [holidays])
NETWORKDAYS.INTL is also available.
Airtable✔ Built inWORKDAY_DIFF(start_date, end_date, [holidays])
Holidays are one text value of comma-separated ISO dates, e.g. "2024-12-25, 2024-12-26". Counts both ends, like NETWORKDAYS.
Notion✘ Not available—
Notion has no working-day function. Calculate the count in a spreadsheet or Airtable, or keep it in a number property; dateBetween(end, start, "days") gives calendar days only.
Try NETWORKDAYS with your own values
One date per line (YYYY-MM-DD)
Result (as Excel & Google Sheets return it)
20
Your formula, ready to paste
Excel=NETWORKDAYS(DATE(2024, 3, 1), DATE(2024, 3, 31), A2:A2) open excel.new ↗
Google Sheets=NETWORKDAYS(DATE(2024, 3, 1), DATE(2024, 3, 31), A2:A2) open sheets.new ↗
AirtableWORKDAY_DIFF(DATETIME_PARSE("2024-03-01", "YYYY-MM-DD"), DATETIME_PARSE("2024-03-31", "YYYY-MM-DD"), "2024-03-29")
Notion✘ No equivalent. Notion has no working-day function. Calculate the count in a spreadsheet or Airtable, or keep it in a number property; dateBetween(end, start, "days") gives calendar days only.

Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.

Holiday
2024-03-29

In Excel and Google Sheets the holidays are a cell range; paste the sample data at A1 first.

Arguments

ArgumentWhat it means
start_dateThe first day of the period (counted if it is a working day).
end_dateThe last day of the period (also counted). If it is before the start, the result is negative.
[holidays] optionalOptional range or list of dates to skip, such as public holidays. Holidays on weekends are not subtracted twice.

Examples

FormulaResultWhyCopy
=NETWORKDAYS(DATE(2024, 3, 1), DATE(2024, 3, 31))21Weekdays in March 2024.
=NETWORKDAYS(DATE(2024, 3, 1), DATE(2024, 3, 31), DATE(2024, 3, 29))20Good Friday removed.
=NETWORKDAYS(DATE(2024, 1, 5), DATE(2024, 1, 8))2Friday to Monday: both ends count, the weekend does not.
=NETWORKDAYS(A2, B2, Holidays!A:A)Days excluding the holiday listKeep holidays on their own sheet and refer to the column.

Examples use Excel / Google Sheets syntax unless noted.

How NETWORKDAYS works

NETWORKDAYS is inclusive: if a task starts and ends on the same Monday, the result is 1, not 0. That differs from plain subtraction (=B2 - A2 gives 0) and from WORKDAY, which counts days after the start. Keep this in mind when converting a duration between the two functions.

Weekends are always Saturday and Sunday. For a Friday–Saturday weekend, a six-day week or part-time schedules, use NETWORKDAYS.INTL(start, end, weekend, [holidays]), where weekend is a code such as 7 (Friday–Saturday) or a seven-character mask like "0000011". Holidays must be real dates; text that only looks like a date is ignored or causes #VALUE!.

Airtable's WORKDAY_DIFF counts the same way, but takes holidays as a single comma-separated string of ISO dates rather than a range. Notion has no working-day function at all, so the tester shows no Notion formula.

Frequently Asked Questions

Why is NETWORKDAYS one more than I expected?
Both the start and end dates are counted. Subtract 1 if you want the days between them.
Can I use a different weekend?
Yes, in Excel and Google Sheets with NETWORKDAYS.INTL. Airtable's WORKDAY_DIFF always uses Saturday and Sunday.

Part of the Date & Time functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.