Another:

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



EricBB wrote:

i need a formula to count only Friday between to dates.

say,
A1=Starting Date
A2=End Date

A3 will be the no. of Friday between A1 & A2

Pls. help....

--

Dave Peterson