one way:

=SUM(IF(WEEKDAY(A1:A19,2)=3,1))

CTRL+SHIFT+ENTER it as it is an array-formula



On 26 Maj, 08:07, 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....