Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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:

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

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 »
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 »