Excel WORKDAY Function

Date Function ยท Intermediate Level

What is WORKDAY?

Returns a date that is a specified number of business days from a start date. Perfect for calculating deadlines and delivery dates.

Syntax

=WORKDAY(start_date, days, [holidays])

Example

Formula: =WORKDAY(TODAY(), 10)

Result: Date 10 business days from now

How It Works

Adds business days (Mon-Fri) to a date, skipping weekends and specified holidays. Negative days calculates backwards.

Learn More Excel Functions