formula for counting only Friday between to dates

[EricBB]

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

 

[Jacob Skaria]

=INT((A2-WEEKDAY(A2+1-6)-A1+8)/7)

 

[Jacob Skaria]

=INT((A2-WEEKDAY(A2+1-6)-A1+8)/7)

 

[Jarek Kujawa]

one way:

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

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

 

[Jarek Kujawa]

one way:

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

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

 

[Jarek Kujawa]

oops, sorry

did not read the post carefully

one way:

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

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






- Poka¿ cytowany tekst -

 

[Jarek Kujawa]

oops, sorry

did not read the post carefully

one way:

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

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






- Poka¿ cytowany tekst -

 

[Dave Peterson]

Another:

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

 

[Dave Peterson]

Another:

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