Scheduling
 

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:


--
jose.rodriguez
------------------------------------------------------------------------
jose.rodriguez's Profile: http://www.excelforum.com/member.php...o&userid=33339
View this thread: http://www.excelforum.com/showthread...hreadid=531692

Scheduling
 

=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"
<jose.rodriguez.262j1b_1144705804.6634@excelforu m-nospam.com wrote in
message news:jose.rodriguez.262j1b_1144705804.6634@excelfo rum-nospam.com...

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:


--
jose.rodriguez
------------------------------------------------------------------------
jose.rodriguez's Profile:
http://www.excelforum.com/member.php...o&userid=33339
View this thread: http://www.excelforum.com/showthread...hreadid=531692

Scheduling
 

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"
<jose.rodriguez.262j1b_1144705804.6634@excelforu m-nospam.com wrote in
message news:jose.rodriguez.262j1b_1144705804.6634@excelfo rum-nospam.com...

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:


--
jose.rodriguez
------------------------------------------------------------------------
jose.rodriguez's Profile:
http://www.excelforum.com/member.php...o&userid=33339
View this thread: http://www.excelforum.com/showthread...hreadid=531692