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
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | WORKDAY(start_date, days, [holidays])WORKDAY.INTL lets you choose other weekend days. |
| Google Sheets | ✔ Built in | WORKDAY(start_date, num_days, [holidays]) |
| Airtable | ✔ Built in | WORKDAY(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. |
| 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 ↗ |
| Airtable | WORKDAY(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
| Argument | What it means |
|---|---|
start_date | The date to count from. It is not counted itself and can fall on a weekend. |
days | Working days to move: positive for the future, negative for the past. Decimals are truncated. |
[holidays] optional | Optional range or list of dates to skip. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=WORKDAY(DATE(2024, 3, 28), 5, C2:C3) | 2024-04-08 | Five 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-18 | One working day after a Friday is Monday. | |
=WORKDAY(DATE(2024, 4, 1), -1) | 2024-03-29 | Negative days go back. | |
=WORKDAY(A2 - 1, 1) | A2, or the next working day | Moves 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.