Networkdays
 

I know the networkdays automatically calculates the monday to friday
routine between two dates. How can I howether compare two dates that
doesn't count friday as a workday also, as well as the normal saturday
and sunday?

Networkdays
 

1 way

=NETWORKDAYS(A10,A11,B8:B40)

where
a10 start date
a11 end date
B8:B40 every friday between those 2 dates (Easy to create with autofill)

Mike


"Dave" wrote:

I know the networkdays automatically calculates the monday to friday
routine between two dates. How can I howether compare two dates that
doesn't count friday as a workday also, as well as the normal saturday
and sunday?

Networkdays
 

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(start_date&":"&end_date)),2) ={1,2,3,4}))
-SUMPRODUCT(--(COUNTIF(holidays,(ROW(INDIRECT(start_date&":"&end _date)))*(WEEKDAY(ROW(INDIRECT(start_date&":"&end_ date)),2)={1,2,3,4}))))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Dave" wrote in message
ups.com...
I know the networkdays automatically calculates the monday to friday
routine between two dates. How can I howether compare two dates that
doesn't count friday as a workday also, as well as the normal saturday
and sunday?

Networkdays
 

If you aren't worried about holidays

=SUM(INT((8-WEEKDAY(end_date-{1,2,3,4})+end_date-start_date)/7))

If you have a range of holidays to exclude

=SUMPRODUCT((WEEKDAY(ROW(INDIRECT(start_date&":"&e nd_date)),2)={1,2,3,4})*(COUNTIF(holidays,ROW(INDI RECT(start_date&":"&end_date)))=0))

"Bob Phillips" wrote:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(start_date&":"&end_date)),2) ={1,2,3,4}))
-SUMPRODUCT(--(COUNTIF(holidays,(ROW(INDIRECT(start_date&":"&end _date)))*(WEEKDAY(ROW(INDIRECT(start_date&":"&end_ date)),2)={1,2,3,4}))))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Dave" wrote in message
ups.com...
I know the networkdays automatically calculates the monday to friday
routine between two dates. How can I howether compare two dates that
doesn't count friday as a workday also, as well as the normal saturday
and sunday?