WORKDAY(start_date, days [,holidays])

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

start_dateThe starting date.
daysThe 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.
* This function excludes weekends and any other dates specified in the "holidays" array.
* This function has an explicit assumption that weekends are Saturday and Sunday. The WORKDAY.INTL function allows you to specify what days you want to treat as weekends.
* 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 be either 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 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.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.com

 ABCD
1=WORKDAY("02/01/2010",0) = 4018001/01/201040179Friday
2=WORKDAY("02/01/2010",1) = 4018202/01/201040180Saturday
3=WORKDAY("02/01/2010",5) = 4018603/01/201040181Sunday
4=WORKDAY("02/01/2010",6) = 4018904/01/201040182Monday
5=WORKDAY("02/01/2010",2,"04/01/2010") = 4018405/01/201040183Tuesday
6=WORKDAY("02/01/2000",2,"03/01/2000") = 3653006/01/201040184Wednesday
7=WORKDAY("02/01/2000",2,B1:B3) = 3652907/01/201040185Thursday
8=WORKDAY("02/01/2000",2,{"03/01/2000","04/01/2000"}) = 36531   
9=WORKDAY("01/01/1977",7,2) = 28136   
10=WORKDAY(1/1/1977,7,2) = 11   
11=WORKDAY(DATE(1977,1,1),7,2) = 28136   
12=WORKDAY(DATEVALUE("01/03/1998"),5) = 35860   
13=WORKDAY("01/02/2000",-10000000) = #NUM!   
14=WORKDAY("30/02/2000",2) = #VALUE!   
15=WORKDAY("02/01/2000",2,"30/02/2000") = #VALUE!   

1 - What is the serial number for the date that is 0 days after 2-January-2010 (40180).
2 - What is the serial number for the date that is 1 day after 2-January-2010 (40180 + 2). Because the 2nd January is Saturday, 1 day would be Monday which is 2 days after.
3 - What is the serial number for the date that is 5 days after 2-January-2010 (40180 + 6). Because the 2nd January is Saturday. 5 days would be Friday which is 6 days after.
4 - What is the serial number for the date that is 6 days after 2-January-2010 (40180 + 9). Because the 2nd January is Saturday 6 days after be the following Monday which is 9 days after.
5 - What is the serial number for the date that is 2 days after 2-January-2010 (40180 + 4). Because the 2nd January is Saturday 2 days after would be Tuesday the 5-January but since the 4-January is considered to be a holiday it will actually be Wednesday which is 4 days after.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top