WORKDAY
Returns the serial number of the date before or after a specified number of workdays.
Date & TimeDates & Time Calculations
What it does
Calculates end date after N workdays.
Syntax
WORKDAY(start_date, days, [holidays])
Arguments
start_date(date) — Start.days(number) — Days to add.holidays(range) — Holiday list.
Examples
Add Workdays
10 working days after Jan 1.
FORMULA
=WORKDAY(DATE(2023,1,1), 10)
RESULT
2023-01-13
SAMPLE DATA
| A | |
|---|---|
| 1 | Date |
| 2 | 2023-01-01 |