Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
WORKDAY
WORKDAY adds or subtracts a specified number of business days (Monday–Friday) to a start date, automatically skipping weekends and any holidays you supply. Use it to calculate delivery dates, project deadlines, or payment due dates that must land on working days.
Excel
=WORKDAY(DATE(2024,1,1),10)Google Sheets
=WORKDAY(DATE(2024,1,1),10)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| StartDate | WorkDays | DueDate |
| 2024-01-01 | 10 | |
| 2024-03-01 | 5 | |
| 2024-06-17 | 15 | |
| 2024-11-25 | 7 |
=WORKDAY(DATE(2024,1,1),10)→45306
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Put the start date in cell A2 and the number of working days to add in cell B2.
- 2In cell C2 type =WORKDAY(A2,B2) to get the resulting working day.
- 3Optionally supply a third argument with a range of holiday dates to exclude them from the count.
Need a version for your data?
Try: “Calculate the delivery date that is 10 business days after each order date”