How to use the Excel WORKDAY function

Summary

The Excel WORKDAY function takes a date and returns the nearest working day in the future or past, based on an offset value you provide. You can use the WORKDAY function to calculate things like ship dates, delivery dates, and completion dates that need to take into account working and non-working days.

Purpose

Get a date n working days in the future or past

Return value

A serial number representing a particular date in Excel.

Syntax

=WORKDAY (start_date, days, [holidays])

Arguments

start_date - The date from which to start.
days - The working days before or after start_date.
holidays - [optional] A list dates that should be considered non-work days.

Usage notes

The WORKDAY function figures out a date that represents the "nearest" working day N days in the past or future. WORKDAY can be used to calculate due dates, delivery dates, and other dates that should exclude non-working days.

Use a positive number for days to calculate future dates, and a negative number for past dates.

Note: WORKDAY does not include the start date date as a work day when it calculates the end date.

Weekends

By default, WORKDAY will exclude weekends (Saturday and Sunday) . If you need to customize which days of the week are considered weekend days, use the more robust WORKDAY.INTL function.

Related functions

Excel WORKDAY.INTL Function

The Excel WORKDAY.INTL function takes a date and returns the nearest working in the future or past, based on an offset value you provide. Unlike the WORKDAY function, WORKDAY.INTL allows...

Excel EDATE Function

The Excel EDATE function returns a date on the same day of the month, n months in the past or future. You can use EDATE to calculate expiration dates, maturity dates, and other due dates. Use a positive value for months to get a date in the...

Excel NETWORKDAYS Function

The Excel NETWORKDAYS function calculates the number of working days between two dates. NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and can optionally exclude a list of holidays supplied as dates.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.