writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + Line 6:
Line 6: − +
no edit summary
=NETWORKDAYS(start_date, end_date, holidays)=
=NETWORKDAYS(start_date, end_date, holidays)=
<div style="font-size:30px">'''NETWORKDAYS (start_date,end_date,holidays)'''</div><br/>
where,
where,
*'''start_date''' represents the starting date,
*'''start_date''' represents the starting date,
*'''holidays''' is an optional range of one or more dates to exclude from the working days.
*'''holidays''' is an optional range of one or more dates to exclude from the working days.
NETWORKDAYS() calculates the number of working days between '''start_date''' and '''end_date''' excluding weekends and holidays.
NETWORKDAYS() returns the number of whole workdays between two dates.
== Description ==
== Description ==