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 !!

=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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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 !!
>
>
>
> --
> 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
>

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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 !!
>
>
>
> --
> 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
>