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_date  The starting date. 
days  The 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 
* This function was added in Excel 2010 to replace the WORKDAY function. * 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 6day 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 

1  What is the serial number for the date that is 0 days after 2January2010 (40180). 2  What is the serial number for the date that is 1 day after 2January2010 (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 2January2010 (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 2January2010 (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 2January2010 (40180 + 4). Because the 2nd January is Saturday 2 days after would be Tuesday the 5January but since the 4January 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