Syntax
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])Arguments
| Argument | Required | Description |
|---|---|---|
start_date | Required | The first date |
end_date | Required | The last date |
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 leave out |
How to use NETWORKDAYS.INTL
NETWORKDAYS.INTL takes 2 required arguments and 2 optional arguments. Type =NETWORKDAYS.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.
=NETWORKDAYS.INTL(DATE(2006,1,1), DATE(2006,1,31))Result =NETWORKDAYS.INTL(DATE(2006,1,1), DATE(2006,2,1), 7, A1:A2)Result Data in the sheet
| A | |
|---|---|
| 1 | 38719 |
| 2 | 38733 |
=NETWORKDAYS.INTL(DATE(2006,2,28), DATE(2006,1,31))Result Related date and time functions
- ISOWEEKNUMReturns the ISO week number of the year (weeks start on Monday, week 1 contains the first Thursday).
- MINUTEReturns the minute (0 to 59) of a time.
- MONTHReturns the month (1 to 12) of a date.
- NETWORKDAYSCounts the working days (Monday to Friday) between two dates, both included, leaving out holidays.
- NOWReturns the current date and time.
- 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.