Count dates in range for Tuesday, Wed & Friday only

[lapta301]

Hi

I have a range of dates in the range G7:G16 but not necessarily in all rows.

I would like a formula to total the number of days only for Tuesday, Wednesday or Friday. That is a complete total not how many for each day.


Many thanks

 

[steve the fish]

See if this works:

=SUMPRODUCT(--(WEEKDAY(G7:G16)={3,4,6}))

 

[steve the fish]

Actually this is better in case you have blanks:

=SUMPRODUCT((WEEKDAY(G7:G16)={3,4,7})*(G7:G16<>""))

 

[lapta301]

Thank you Steve that works a treat.

Much appreciated