Get Nthworking day before and after a given date.
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.
=WORKDAY(start_date, days, [holidays])
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.
Working date as per arguments.
- 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