formula for counting only Friday between to dates
 

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

formula for counting only Friday between to dates
 

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

formula for counting only Friday between to dates
 

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

formula for counting only Friday between to dates
 

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 -

formula for counting only Friday between to dates
 

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