WORKDAY
Finds the date a number of working days away.
How it’s written
WORKDAY(start, days)Example
| A | |
|---|---|
| 1 | Start |
| 2 | 46,097 |
=WORKDAY(A2,5)Result: 46,104
Five working days after a Monday is the next Monday.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Ideal for working out delivery and due dates.
Practice it properly
Tenure and working days gives you real tasks, with your formulas tested on data you haven’t seen.