Changes

=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,

*'''end_date''' represents the end date, and

*'''end_date''' represents the end date, and

*'''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() returns the number of whole workdays between two dates.

NETWORKDAYS() calculates the number of working days between '''start_date''' and '''end_date''' excluding weekends and holidays.

== Description ==

== Description ==

*'''start_date''', '''end_date''' and '''holidays''' should be entered either in 'date format' or 'dates returned using formulas'.

*'''start_date''', '''end_date''' and '''holidays''' should be entered either in 'date format' or 'dates returned using formulas'.

*If date values are invalid, Calci displays #NULL error message.

*If date values are invalid, Calci displays #NULL error message.

*We can use Range values also. For Example: NETWORKDAYS(DATE(2012,6,1),#12/31/2012-12/31/2013)

*We can use Range values also. For Example: NETWORKDAYS(DATE(2012,6,1),#12/31/2012-12/31/2013)

* #date notation needs  mm/dd/yy format .

* #date notation needs  mm/dd/yy format .