WORKDAY

WORKDAY(start_date, days [,holidays])

Returns the date serial number that is a given number of working days before or after a date.

start_date	The starting date.
days	The number of nonweekend and nonholiday days before or after "start_date".
holidays	(Optional) The dates to exclude from the working calendar, holidays and floating days.

REMARKS

* WORKDAY.INTL was added in Excel 2010 to replace this function and to let you choose what days you want to treat as weekends.
* This function can be used to calculate the end date (given a start date and total days).
* This function has an explicit assumption that weekends are Saturday and Sunday.
* This function will exclude weekends as well as any other dates specified in the "holidays" array.
* If "start_date" is not a valid date, then #VALUE! is returned.
* If "start_date" plus "days" yields an invalid date, then #NUM! is returned.
* If "days" is not an integer, it is truncated.
* If "days" > 0, then a future date is returned.
* If "days" < 0, then an earlier date is returned.
* The "holidays" can either be a range of cells that contain the dates or an array constant of the serial numbers that represent the dates.
* If "holidays" is left blank, then only weekends will be excluded.
* If "holidays" has more than one date, you can either use an array constant or refer to a cell range.
* If "holidays" contains an invalid date, then #VALUE! is returned.
* You can use the DATE function to return the date as a date serial number given a year, month, day.
* You can use the DATEVALUE function to return the date serial number given a date in text format.
* You can use the DAYS function to return the number of days between two dates.
* You can use the DAYS360 function to return the number of days between two dates, based on 30 day months.
* You can use the NETWORKDAYS function to return the number of working days between two dates excluding weekends and holidays.
* You can use the NETWORKDAYS.INTL function to return the number of working days between two dates excluding weekends and holidays.
* You can use the WEEKDAY function to return the day of the week for a given date.
* You can use the WORKDAY.INTL function to return the date serial number that is a given number of working days before or after a date.
* You can use the WORKDAY6 - User Defined Function function to assume a 6-day working week.
* You can use the WORKDAYSMISC - User Defined Function function to use other days as your workdays.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B
1	=WORKDAY("1 Jan 2022", 0) = 44562	Sat, 1 Jan 2022
2	=WORKDAY("1 Jan 2022", 1) = 44564	Sun, 2 Jan
3	=WORKDAY("1 Jan 2022", 5) = 44568	Mon, 3 Jan
4	=WORKDAY("1 Jan 2022", 6) = 44571	Tue, 4 Jan
5	=WORKDAY("2 Jan 2022", 2, "3 Jan 2022") = 44566	Wed, 5 Jan
6	=WORKDAY("2 Jan 2022", 2, "4 Jan 2022") = 44566	Thu, 6 Jan
7	=WORKDAY("2 Jan 2022", 2, {"3 Jan 2022", "4 Jan 2022"}) = 44567	Fri, 7 Jan
8	=WORKDAY("10 Jan 2022", - 5) = 44564	Sat, 8 Jan
9	=WORKDAY( DATE(2022, 1, 1), 1) = 44564	Sun, 9 Jan
10	=WORKDAY( DATEVALUE("01/01/2022"), 1) = 44564	Mon, 10 Jan
11	=WORKDAY(1/1/1977, 1) = 2
12	=WORKDAY("2 Jan 2024", "text") = #VALUE!
13	=WORKDAY("2 Jan 2024", #REF!) = #REF!
14	=WORKDAY("01/02/2024", - 10000000) = #NUM!
15	=WORKDAY("30/02/2024", 2) = #VALUE!

1 - What is the serial number for the date that is 0 days after 1 Jan 2022 (44562 + 0).
2 - What is the serial number for 1 day after 1 Jan 2022. The 1 Jan is Saturday, so the next working day would be Monday which is 2 days after. (44562 + 2)
3 - What is the serial number for 5 days after 1 Jan 2022. The 1 Jan is Saturday, so 5 working days after would be Friday which is 6 days after. (44562 + 6)
4 - What is the serial number for 6 days after 1 Jan 2022. The 1 Jan is Saturday, so 6 working days after would be the following Monday which is 9 days after. (44562 + 9)
5 - What is the serial number for 2 days after 2 Jan 2022. The 2 Jan is Sunday, so 2 working days after would be Tuesday but since the 3 Jan is considered to be a holiday it will actually be Wednesday which is 4 days after. (44562 + 4)
6 - What is the serial number for 2 days after 2 Jan 2022. The 2 Jan is Sunday, so 2 working days after would be Tuesday but since the 4 Jan is considered to be a holiday it will actually be Wednesday which is 4 days after. (44562 + 4)
7 - What is the serial number for 2 days after 2 Jan 2022. The 2 Jan is Sunday, so 2 working days after would be Tuesday but since both the 3 Jan and 4 Jan are considered to be a holidays it will actually be Thursday which is 5 days after. (44562 + 5)
8 - What is the serial number for 5 days before 10 Jan 2022. The 10 Jan is Monday, so 5 working days before would be Monday, which is 7 days before (44571 - 7)
9 - This is the same as Example 2 using the DATE function.
10 - This is the same as Example 2 using the DATEVALUE function.
11 - This is not a valid date and is just a very small value.
12 - The days argument is not numeric.
13 - The days argument is #REF!.
14 - The date returned is not valid.
15 - The start_date argument is not a valid date.