Syntax
=WORKDAY.INTL(start_date, days, [weekend], [holidays])Arguments
| Argument | Required | Description |
|---|---|---|
start_date | Required | The starting date |
days | Required | Working days to add (negative to go back) |
weekend | Optional | A weekend number (1 to 7, 11 to 17) or a 7 character mask like "0000011" starting on Monday |
holidays | Optional | Optional dates to skip |
How to use WORKDAY.INTL
WORKDAY.INTL takes 2 required arguments and 2 optional arguments. Type =WORKDAY.INTL( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=WORKDAY.INTL(DATE(2012,1,1), 30, 0)Result =WORKDAY.INTL(DATE(2012,1,1), 90, 11)Result =WORKDAY.INTL(DATE(2012,1,1), 30, 17)Result Related date and time functions
- SECONDReturns the second (0 to 59) of a time.
- TIMEBuilds a time of day from hours, minutes and seconds.
- TIMEVALUEConverts a time written as text into a fraction of a day.
- TODAYReturns the current date.
- WEEKDAYReturns the day of the week of a date as a number (by default 1 for Sunday to 7 for Saturday).
- WEEKNUMReturns the week number of a date in its year (the week containing January 1 is week 1).
- WORKDAYReturns the date a number of working days (Monday to Friday) before or after a date, skipping holidays.
- YEARReturns the year of a date.
- YEARFRACReturns the fraction of a year between two dates using a day count basis.