Date
Shifting a date by weekdays
Definition
Shifting a date by a number of workdays means giving WORKDAY the start date and how many workdays to add.
Syntax
=WORKDAY(start_date, days)
Arguments
| Argument | Meaning |
|---|---|
start_date |
The date to shift from. |
days |
How many workdays to add. Saturday and Sunday are skipped. |
Worked example
A print shop stores the send date in B2 and needs the date one workday later.
| A: Job | B: Send |
|---|---|
| Cards | 10 May 2024 |
| Menus | 14 May 2024 |
| Tags | 17 May 2024 |
Formula: =WORKDAY(B2,1)
Result: 45425. 10 May 2024 is a Friday, so one workday later is Monday 13 May 2024.
Practice
Cell A2 holds the date 3 June 2024. In B2, write a formula that returns the date two workdays after A2.
- In B2, write a WORKDAY formula that adds 2 workdays to A2.
- B2 should show A2 plus 2 workdays.
Step 1 of 2
Enter =WORKDAY(A2,2) in B2.
Two workdays after 3 June 2024 is 5 June 2024, which is 45448.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
B2 uses WORKDAY.
B2 now shows 45448.
The next lesson is Taking the gap between two numbers.
Related functions
WORKDAY is the function that adds those workdays and skips weekend days.
Common mistake
Adding calendar days, as in =B2+1: Friday becomes Saturday instead of the next workday, Monday.