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
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | NETWORKDAYS(start_date, end_date, [holidays])NETWORKDAYS.INTL lets you choose other weekend days. |
| Google Sheets | ✔ Built in | NETWORKDAYS(start_date, end_date, [holidays])NETWORKDAYS.INTL is also available. |
| Airtable | ✔ Built in | WORKDAY_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. |
| 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 ↗ |
| Airtable | WORKDAY_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
| Argument | What it means |
|---|---|
start_date | The first day of the period (counted if it is a working day). |
end_date | The last day of the period (also counted). If it is before the start, the result is negative. |
[holidays] optional | Optional range or list of dates to skip, such as public holidays. Holidays on weekends are not subtracted twice. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=NETWORKDAYS(DATE(2024, 3, 1), DATE(2024, 3, 31)) | 21 | Weekdays in March 2024. | |
=NETWORKDAYS(DATE(2024, 3, 1), DATE(2024, 3, 31), DATE(2024, 3, 29)) | 20 | Good Friday removed. | |
=NETWORKDAYS(DATE(2024, 1, 5), DATE(2024, 1, 8)) | 2 | Friday to Monday: both ends count, the weekend does not. | |
=NETWORKDAYS(A2, B2, Holidays!A:A) | Days excluding the holiday list | Keep 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.