The WORKDAY function
Returns the date a number of working days before or after a start date, skipping weekends and any holidays you list.
Syntax
WORKDAY(start_date, days, [holidays])- start_date
- The date to count from. It is not counted itself.
- days
- Working days to move. A negative number counts back.
- holidays (optional)
- Dates to skip as well, such as public holidays.
Examples
B1=TEXT(WORKDAY(DATE(2024,3,15),5),"mmm d, yyyy")
| A | B | |
|---|---|---|
| 1 | Mar 22, 2024 |
B1=TEXT(WORKDAY(DATE(2024,3,28),1,DATE(2024,3,29)),"mmm d, yyyy")
| A | B | |
|---|---|---|
| 1 | Apr 1, 2024 |
B1=TEXT(WORKDAY(DATE(2024,3,18),-1),"mmm d, yyyy")
| A | B | |
|---|---|---|
| 1 | Mar 15, 2024 |
Practice WORKDAY
Questions
Why does WORKDAY return a number like 45373?
Excel stores dates as numbers, and the result cell has no date format. Format the cell as a date (Ctrl+1 > Date). The examples here wrap the result in TEXT so the date is readable.
What if my weekend is not Saturday and Sunday?
Use WORKDAY.INTL, which takes a weekend code, such as 7 for Friday and Saturday, before the holidays.