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