Networkdays

[makinsond]

I use the NETWORKDAYS command to calculate the number of working days between 2 dates. NETWORKDAYS treats Saturday and Sunday as non-working days and omits them from the calculation.

I have a client who regards Saturday as a working day so I either need to find a version of Networkdays which only regards Sunday as a non-working day or a calculation which will count the number of Sundays between 2 dates.

 

[2rrs]

have a look here: http://www.mrexcel.com/board2/viewtopic.php?t=72395


The following formula from Harlan Grove (Microsoft Excel MVP)
mimics Excel’s Networkdays function:
=SUMPRODUCT(--(COUNTIF(Holidays,ROW(INDIRECT(A2&":"&B2)))=0),--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)),3)<6))

Where:
A2: 1 November 03 (start date)
B2: 31 March 04 (end date)

“Holidays” is a named range that covers holidays for the year.

The above formula returns an identical result to:
=NETWORKDAYS(A2,B2,Holidays) but includes Saturdays and excludes Sundays.