WORKDAY

Get a date n working days in the future or past

Sponsored Link

WORKDAY

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.

Weekends

WORKDAY excludes excludes weekends by default, and dates supplied as holidays. 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.

Sponsored Link

0 votes. 0 / 5