Scheduling

[jose.rodriguez]

Probably for you this is very easy, I am trying to get how many
saturdays and
sundays are between 2 dates, this using a single worksheet in excel. In
cell A1
provide the start date, in cell B1 provide finish date, and in cell C1
get how
many saturdays and sundays there are.

Would you mind help me in this trouble.

Best Regards !!

 

[Bob Phillips]

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=6))

where a1 and B1 hold the start and end dates

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jose.rodriguez"

 

[Bob Phillips]

Sorry, that should be

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))={1,7}))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jose.rodriguez"