The WORKDAY.INTL function calculates a workday a given number of days away from a date. You can optionally specify a list of holidays to exclude from the count and different weekends. If your days, months, and years are in different cells, use the DATE function to combine them. This function is different from the WORKDAY function because you can also specify different weekends.
start_date– The date from which to start counting the days.
days– The number of days to add to the start_date
- Number method
- 1 – Saturday and Sunday [don’t need to specify]
- 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 method – Each digit represents a day. First digit is Monday.
- 0000011 – Saturday and Sunday
- 0100000 – Only Tuesday
- Number method
[holidays]– Optional specification of which days are to be excluded from the count of work days.
WEEKDAY – Returns the week number for a given date.
DAYS – Find the number of days between two dates.
NETWORKDAYS.INTL – Calculate the number of working days in between two days and exclude specified days as weekends.
NETWORKDAYS – Calculate the number of working days in between two days and exclude weekends.
WORKDAY – Like this function but with Saturday and Sunday as the weekends only.
#NUM – The inputs are numbers but are not valid dates. This could happen if you used the 35th day of November, “11/35/2018”.
#VALUE! – The inputs are something that doesn’t convert to a number such as “The other day” or “Yester-yester-day”.
Live examples in Sheets
Go to this spreadsheet for the examples of the WORKDAY.INTL function shown above that you can study and use anywhere you would like.