The formula
Excel & Google SheetsExcelGoogle Sheets
=WORKDAY(A2,B2,D2:D3)In F2 → Dec 31, 2026
10 working days backExcelGoogle Sheets
=WORKDAY(A2,-10,D2:D3)In F3 → Dec 8, 2026
Fri–Sat weekendExcelGoogle Sheets
=WORKDAY.INTL(A2,B2,7,D2:D3)In F4 → Dec 30, 2026
✓ Tested. All 3 Excel results in this example were recalculated in LibreOffice Calc 25.2 and matched the values shown.
Worked example
Paste the data below into a blank sheet starting at cell A1 (or download the cheat sheet, where every example is set up). Highlighted cells hold the formulas and show the expected results.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Start | Days | Holidays | |||
| 2 | Dec 22, 2026 | 5 | Dec 24, 2026 | Dec 31, 2026 | ||
| 3 | Dec 25, 2026 | Dec 8, 2026 | ||||
| 4 | Dec 30, 2026 |
How it works
- A2
- Start date (not counted).
- B2
- Working days to add; negative goes back.
- D2:D3
- Holidays to skip.
- 7
- WORKDAY.INTL weekend code: 7 = Friday and Saturday.
Common errors and fixes
Shows a number like 46387?
Format the cell as a date.
Why does the formula return #VALUE!?
Start date is text.
Does this work in Google Sheets?
Yes. The formulas on this page work the same way in Google Sheets.