Next working day
| A | |
|---|---|
| 1 | Order date |
| 2 | 3/8/2024 |
Formula: C2: =WORKDAY(A2,1)
Result: 3/11/2024
March 8, 2024 is a Friday, so the next working day is Monday, March 11.
Google Sheets function
WORKDAY in Google Sheets
WORKDAY skips Saturday and Sunday only; Google Sheets has WORKDAY.INTL for other weekends.
Syntax (same in Google Sheets)
WORKDAY(start_date, days, [holidays])List public holidays on the sheet and pass that range as the third argument.
For a fuller explanation of the arguments and common errors, see the WORKDAY Excel guide.
Worked examples in Google Sheets
Five working days
| A | |
|---|---|
| 1 | Order date |
| 2 | 3/8/2024 |
Formula: C2: =WORKDAY(A2,5)
Result: 3/15/2024
The five working days are Monday to Friday, ending on March 15.
With a holiday
| A | B | |
|---|---|---|
| 1 | Order date | Holiday |
| 2 | 3/8/2024 | 3/11/2024 |
Formula: D2: =WORKDAY(A2,1,B2)
Result: 3/12/2024
Monday the 11th is a listed holiday, so the answer moves to Tuesday.
Try it
A tiny spreadsheet with example data. Edit the formula or any number and see the result.
Formula in F2: =WORKDAY(A2,10,C2:C3)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Start | End | Holiday | Time | Result | |
| 2 | 3/15/2026 | 6/20/2026 | 5/1/2026 | 14:45 | 3/27/2026 | |
| 3 | 1/31/2026 | 2/28/2026 | 5/9/2026 | 09:30 | ||
| 4 | 12/24/2025 | 1/9/2026 |
Result in F2: 3/27/2026
Frequently asked questions
- How do I add working days when my weekend is different in Google Sheets?
- Use WORKDAY.INTL, which lets you choose the weekend days. WORKDAY itself assumes Saturday and Sunday.
Google Sheets is used here only as a descriptive product name. FormulaCamp is not affiliated with Google.