NETWORKDAYS | google sheet networkdays
Returnsthenumberofnetworkingdaysbetweentwoprovideddays.SampleUsage NETWORKDAYS(DATE(1969,7,16),DATE(1969,7,24))NETWORKDAYS(A2,B2)NETWORKDAYS(40909,40924)NETWORKDAYS(40900,40950,{40909,40924})SyntaxNETWORKDAYS(start_date,end_date,[holidays])start_date-Thestartdateoftheperiodfromwhichtocalculatethenumberofnetworkingdays.end_date-Theenddateoftheperiodfromwhichtocalculatethenumberofnetworkingdays.holidays-[OPTIONAL]-Arangeorarrayconstantcontainingthedateserialnumberstoconsiderholidays.Thevaluesp...
Returns the number of net working days between two provided days.
Sample UsageNETWORKDAYS(DATE(1969,7,16),DATE(1969,7,24))
NETWORKDAYS(A2,B2)
NETWORKDAYS(40909,40924)
NETWORKDAYS(40900,40950,{40909,40924})
SyntaxNETWORKDAYS(start_date, end_date, [holidays])
start_date - The start date of the period from which to calculate the number of net working days.
end_date - The end date of the period from which to calculate the number of net working days.
holidays - [ OPTIONAL ] - A range or array constant containing the date serial numbers to consider holidays.
The values provided within an array for holidays must be date serial number values, as returned by N or date values, as returned by DATE[1], DATEVALUE[2] or TO_DATE[3]. Values specified by a range should be standard date values or date serial numbers. NotesNETWORKDAYS does not autoconvert number formats in the same way t...