What is the WORKDAY Function
The WORKDAY function returns the date that is a specified number of working days before or after a starting date. It automatically excludes weekends and optionally any holidays you specify.
Formula: =WORKDAY(start_date, days, [holidays])
Practical Example 1
Start A2, add 10 working days.
Type: =WORKDAY(A2, 10)
Result: the date 10 working days later
Practical Example 2
Exclude holidays in D2:D5.
Type: =WORKDAY(A2, 10, D2:D5)
Result: the date accounting for holidays
Practical Example 3
Calculate a delivery date.
Type: =WORKDAY(OrderDate, 5)
Result: the delivery date 5 working days after order
When to Use It
WORKDAY is used for calculating delivery dates, for project due dates, for invoice due dates, for SLA deadlines, and for any formula where you need the date N working days from now.