Manuals/calci/NETWORKDAYS
Jump to navigation
Jump to search
NETWORKDAYS(start_date,end_date,holidays)
where,
start_date - a date that represents the start date
end_date - a date that represents the end date.
holidays - an optional range of one or more dates to except from the working period
Calci returns the number of working days between start_date and end_date except weekends and holidays.
If any parameter is not valid date, NETWORKDAYS returns NaN.
NETWORKDAYS
Lets see an example in (Column2,Row1)
=NETWORKDAYS(R1C1,R2C1)
NETWORKDAYS returns 24.
Consider another example (Column2,Row2)
=NETWORKDAYS(R1C1,R2C1,[R4C1])
NETWORKDAYS returns 23.
Example in (Column2,Row3)
=NETWORKDAYS(RIC1,R2C1,R3C1:R4C1)
It returns 22.
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1/1/2008 | 24 | ||
| Row2 | 2/2/2008 | 23 | ||
| Row3 | 1/2/2008 | 22 | ||
| Row4 | 1/18/2008 | |||
| Row5 | ||||
| Row6 |
