WORKDAY.INTL

WORKDAY.INTL(start_date, days [,weekend] [,holidays])

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

start_dateThe starting date.
daysThe number of workdays before or after the start date.
weekend(Optional) The number indicating which days to consider weekends:
1 = Saturday and Sunday (default)
2 = Sunday and Monday
3 = Monday and Tuesday
4 = Tuesday and Wednesday
5 = Wednesday and Thursday
6 = Thursday and Friday
7 = Friday and Saturday
11 = Sunday only
12 = Monday only
13 = Tuesday only
14 = Wednesday only
15 = Thursday only
16 = Friday only
17 = Saturday only
String Representation (eg 0000011)
holidays(Optional) A array of dates to exclude from the working calendar, holidays and floating days.

REMARKS
* If "start_date" is not an integer, it is truncated.
* If "start_date" is not a valid date, then #VALUE! is returned.
* If "start_date" plus "days" is not a valid date, then #VALUE! is returned.
* If "start_date" is out of range, 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.
* If "days" = 0, then "start_date" is returned.
* The "weekend" can also use a string representation for your weekend. The string must be 7 characters and only contain characters 1 and 0. For example 0000011 represents Saturday and Sunday.
* If "weekend" is left blank, then 1 is used.
* If "weekend" is an invalid string, then #VALUE! 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 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.INTL function to return the number of days 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 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.
* This function was added in Excel 2010 to replace the WORKDAY function.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 ABCD
1=WORKDAY.INTL("02/01/2010", 0) = 4018001/01/201040179Friday
2=WORKDAY.INTL("02/01/2010", 1) = 4018202/01/201040180Saturday
3=WORKDAY.INTL("02/01/2010", 5) = 4018603/01/201040181Sunday
4=WORKDAY.INTL("02/01/2010", 6) = 4018904/01/201040182Monday
5=WORKDAY.INTL("02/01/2010", 2, "04/01/2010") = #VALUE!05/01/201040183Tuesday
6=WORKDAY.INTL("02/01/2000", 2, "03/01/2000") = #VALUE!06/01/201040184Wednesday
7=WORKDAY.INTL("02/01/2000", 2, B1:B3) = #NUM!07/01/201040185Thursday
8=WORKDAY.INTL("02/01/2000", 2, {"03/01/2000", "04/01/2000"}) = #VALUE!   
9=WORKDAY.INTL("01/01/1977", 7, 2) = 28137   
10=WORKDAY.INTL(1/1/1977, 7, 2) = 11   
11=WORKDAY.INTL( DATE(1977, 1, 1), 7, 2) = 28137   
12=WORKDAY.INTL( DATEVALUE("01/03/1998"), 5) = 35860   
13=WORKDAY.INTL("01/02/2000", -10000000) = #NUM!   
14=WORKDAY.INTL("30/02/2000", 2) = #VALUE!   
15=WORKDAY.INTL("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.

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