← Back to level 2
Level 2Next
WORKDAY
A medium planning formula for moving a date forward by a set number of workdays.
Syntax
=WORKDAY(...)Step-by-step explanation
- 1Use a date or time formula when the result should update automatically.
- 2Place the function in the cell where you need a live date or time value.
- 3Format the cell if needed so the output is easy to read.
Common mistakes
Confusing workdays with calendar days
Ignoring the holiday list when needed
Starting from an invalid date cell
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 68 |
Formula
=WORKDAY(A1:B2)
Result
68
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =WORKDAY(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 68.
Practice area
Use WORKDAY when a deadline must skip weekends or custom holidays.
Match against the syntax block above.
Real-life use cases
Due datesProject planningLeave schedules
Related formulas