Count Day of Week formula

[sunrise06]

I could use help with a formula. I have a column of dates and in another set of cells I would like to count the number of those dates that fall on a Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, or Saturday.

Suggestions?

Thanks!

 

[Jonmo1]

I would like to count the number of those dates that fall on a Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, or Saturday.

Isn't that ALL of them?

Or do you mean you want 7 formulas, one to count Sunday, one for Monday etc.. ?

Try
=SUMPRODUCT(--(A1:A100<>""),--(WEEKDAY(A1:A100)-1))

The 1 is for Sunday, change to 2 for Monday, 3 for Tuesday etc...

 

[gaz_chops]

Jonmo1 that doesn't appear to work, I have 1st to 31st Jan in Col A it returns 99 for Sunday.

 

[Jonmo1]

Ugh..typo..

=SUMPRODUCT(--(A1:A100<>""),--(WEEKDAY(A1:A100)-1))
should be
=SUMPRODUCT(--(A1:A100<>""),--(WEEKDAY(A1:A100)=1))

 

[sunrise06]

Thanks for the correction! Exactly what I need!

 

[Jonmo1]

Glad to help, thanks for the feedback.

Thanks to Chops for noting the problem.