Spreadsheet formulas explained, side by side

WORKDAY Function in Excel, Google Sheets, Airtable & Notion

WORKDAY returns the date that is a given number of working days (Monday to Friday) after or before a start date, skipping any holidays you list.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inWORKDAY(start_date, days, [holidays])
WORKDAY.INTL lets you choose other weekend days.
Google Sheets✔ Built inWORKDAY(start_date, num_days, [holidays])
Airtable✔ Built inWORKDAY(start_date, num_days, [holidays])
Holidays are one text value of comma-separated ISO dates, e.g. "2024-12-25, 2024-12-26".
Notion✘ Not available—
Notion has no working-day function. Use dateAdd(date, n, "days") for calendar days, or work out the due date in a spreadsheet or Airtable.
Try WORKDAY with your own values
Negative counts backwards
One date per line (YYYY-MM-DD)
Result (as Excel & Google Sheets return it)
Mon, Apr 8, 2024 2024-04-08 · stored as serial number 45390 in Excel and Sheets
Your formula, ready to paste
Excel=WORKDAY(DATE(2024, 3, 28), 5, A2:A3) open excel.new ↗
Google Sheets=WORKDAY(DATE(2024, 3, 28), 5, A2:A3) open sheets.new ↗
AirtableWORKDAY(DATETIME_PARSE("2024-03-28", "YYYY-MM-DD"), 5, "2024-03-29, 2024-04-01")
Notion✘ No equivalent. Notion has no working-day function. Use dateAdd(date, n, "days") for calendar days, or work out the due date in a spreadsheet or Airtable.

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
2024-04-01

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

Arguments

ArgumentWhat it means
start_dateThe date to count from. It is not counted itself and can fall on a weekend.
daysWorking days to move: positive for the future, negative for the past. Decimals are truncated.
[holidays] optionalOptional range or list of dates to skip.

Examples

FormulaResultWhyCopy
=WORKDAY(DATE(2024, 3, 28), 5, C2:C3)2024-04-08Five working days after Thursday 28 March; C2:C3 hold the Easter holidays 29 March and 1 April.
=WORKDAY(DATE(2024, 3, 15), 1)2024-03-18One working day after a Friday is Monday.
=WORKDAY(DATE(2024, 4, 1), -1)2024-03-29Negative days go back.
=WORKDAY(A2 - 1, 1)A2, or the next working dayMoves a weekend date forward to Monday and leaves weekdays unchanged.

Examples use Excel / Google Sheets syntax unless noted.

How WORKDAY works

WORKDAY is the function for due dates expressed in business days: “payment within 10 working days” is =WORKDAY(A2, 10, Holidays). The start date itself is never counted, so WORKDAY(Friday, 1) is the following Monday, and with 0 days the start date comes back unchanged even if it is a Saturday. Like the other date functions, Excel shows the result as a serial number until the cell is formatted as a date.

WORKDAY and NETWORKDAYS count differently: NETWORKDAYS includes the start date, WORKDAY does not. So NETWORKDAYS(A2, WORKDAY(A2, 10)) is 11 when A2 is a weekday. For other weekends use WORKDAY.INTL(start, days, weekend, [holidays]) with the same weekend codes as NETWORKDAYS.INTL.

Airtable has a WORKDAY function with the same idea; pass holidays as one string of comma-separated ISO dates. Notion has no working-day function, so there is no Notion formula here.

Frequently Asked Questions

How do I move a date to the next working day if it falls on a weekend?
Use =WORKDAY(A2 - 1, 1): step back one day, then forward one working day.

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.