Get the date (serial value) after the specified number of business days.
How it works
WORKDAY
Fix weekends as Saturdays and Sundays.
=WORKDAY(start_date, days, holidays)
Argument | Omission | Specify |
---|---|---|
start_date | Required argument. | The date of the object of the calculation. |
days | Required argument. | Specify the number of days to be calculated. Positive numbers are calculated in the future, negative numbers in the past. |
holidays | Specify dates to exclude from calculation results, such as holidays. |
WORKDAY.INTL
Specify the day of the week for the weekend.
=WORKDAY.INTL(start_date, days, weekend, holidays)
Argument | Omission | Specify |
---|---|---|
start_date | Required argument. | The date of the object of the calculation. |
days | Required argument. | Specify the number of days to be calculated. Positive numbers are calculated in the future, negative numbers in the past. |
weekend | 1 | Weekend Patterns. |
holidays | Specify dates to exclude from calculation results, such as holidays. |
weekend
weekend | Weekend Pattern |
---|---|
1 | Saturday, Sunday |
2 | Sunday, Monday |
3 | Monday, Tuesday |
4 | Tuesday, Wednesday |
5 | Wednesday, Thursday |
6 | Thursday, Friday |
7 | Friday, Saturday |
11 | Sunday only |
12 | Monday only |
13 | Tuesday only |
14 | Wednesday only |
15 | Thursday only |
16 | Friday only |
17 | Saturday only |
Example Results
Prepare a worksheet for calculations and a worksheet for holidays.
function to calculate the date taking into account holidays.
"holidays" can be applied not only to public holidays but also to private holidays.
---