Returns the number of net working days between two provided days.
NETWORKDAYS(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.
NETWORKDAYSdoes not auto-convert number formats in the same way as Google Sheets does upon direct entry into cells. Therefore,
NETWORKDAYS(10/10/2000,10/10/2001)is interpreted as
NETWORKDAYS(0.005,0.00499750124938), the quotients of 10 divided by 10 divided by 2000 and 2001, respectively.
NETWORKDAYScalculates the number of workdays between two dates. To calculate the working day a specific number of days ahead of a date, use
NETWORKDAYSworks in a similar way to NETWORKDAYS.INTL, but only treats Saturday and Sunday as the weekend. Use
NETWORKDAYS.INTLto use other days of the week as the weekend.
NETWORKDAYS.INTL: Returns the number of net working days between two provided days excluding specified weekend days and holidays.
WORKDAY: Calculates the end date after a specified number of working days.
TO_DATE: Converts a provided number into a date.
N: Returns the argument provided as a number.
DATEVALUE: Converts a provided date string in a known format into a date value.
DATE: Converts a year, month and day into a date.
Returns the number of workdays between the
start_date and end_date (based on the given list of holidays).