=INT((A2-WEEKDAY(A2+1-6)-A1+8)/7)
--
If this post helps click Yes
---------------
Jacob Skaria


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