Scheduling

J

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 !!
:cool:
 
B

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"
 
B

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top