How can we help?
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.
holidaysmust be date serial number values, as returned by
Nor date values, as returned by
TO_DATE. Values specified by a range should be standard date values or date serial numbers.
NETWORKDAYS does not autoconvert number formats in the same way that Excellentable 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.
NETWORKDAYS calculates the number of work days between two dates. To calculate the working day a specific number of days ahead of a date, use
NETWORKDAYSworks similarly to
NETWORKDAYS.INTLbut 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 number of working days from a specified start date.
TO_DATE: Converts a provided number to a date.
N: Returns the argument provided as a number.
DATEVALUE: Converts a provided date string in a known format to a date value.
DATE: Converts a provided year, month, and day into a date.