Syntax
=NETWORKDAYS(start_date, end_date, [holidays])Arguments
| Argument | Required | Description |
|---|---|---|
start_date | Required | The first date |
end_date | Required | The last date |
holidays | Optional | Optional dates to leave out |
How to use NETWORKDAYS
NETWORKDAYS takes 2 required arguments and 1 optional argument. Type =NETWORKDAYS( 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(DATE(2012,10,1), DATE(2013,3,1))Result =NETWORKDAYS(DATE(2012,10,1), DATE(2013,3,1), DATE(2012,11,22))Result Related date and time functions
- HOURReturns the hour (0 to 23) of a time.
- 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.
- NETWORKDAYS.INTLCounts the working days between two dates, both included, with a choice of weekend days and 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.