oops, sorry

did not read the post carefully

On 26 Maj, 08:35, Jarek Kujawa wrote:
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....- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -