WORKDAY

Get Nth working day before and after a given date in Excel
Returns the serial number of the date before or after a specified number of workdays

Rational

Get Nthworking day before and after a given date.

Description

The Excel WORKDAY function calculates a date based on a specified number of working days before and after a given starting date. Example; to find two days after a date ‘01-11-2018’ excluding weekends, use =WORKDAY(date,2) that returns 2.

Syntax

=WORKDAY(start_date, days, [holidays])

Parameters

start_date – The Start date
days – Number working days before or after start_date
holidays [optional] – A list of additional days to exclude apart from weekends.

Return Value

Working date as per arguments.

Key Notes

  • The WORKDAY() function find a working day after some days from a starting date. The function returns the nearest working day after automatically excluding weekend days (Saturdays and Sundays).
  • As with all dates in Excel, what you end up with is a serial number, but the Date formatting displays the date in a readable fashion.
  • Although optional, you can also specify the list of holidays to exclude from the result as with the NETWORKDAYS function.
  • The result includes the start_date as the first date for calculating return value. The second argument for the WORKDAY function can be positive or negative for calculating future or past date respectively.
  • To find working days without excluding days Saturday and Sunday use WORKDAYS.INTL

Keep Reading Similar Functions:

Find a number of working days between a date range in Excel

WORKDAYS.INTL

WORKDAYS.INTL returns a working day before and after a date, excl. custom Weekend days i.e. to find a working day 2 days after a date (01-11-2018-B7) excluding Friday and Saturday, =WORKDAY.INTL(B7,2,7), returns ‘05-11-2018’.

Read More »
Return a month before or after the start date in Excel

EDATE

The EDATE function returns a future or past month from a given date. I.e., =EDATE(“31-03-2016”,-1) returns a leap date 29-02-2016 as 2016 is a leap year.

Read More »
Find a number of working days between a date range in Excel

NETWORKDAYS

The NETWORKDAYS function returns a number of working days between two dates, 01-11-2018 (B6) and 31-12-2018 (C6), use =NETWORKDAYS(B6,C6) that returns ‘43’.

Read More »