Question for the experts

[tford]

Hey Folks,

Long time lurker, first time poster so be gentle.

Having an issue, our software program returns a list of dates in day/month/year. We have the cells formatted to show up as Wednesday, January 12 2018 for example. I thing is, is there anyway to get excel to count how many times the dates fall on specific days of the week, Monday through Sunday. I know i'll need a cell for each day of the week by i can't seem to get it working as the actual value is day/month/year.

Any help?
Thanks in advanced

 

[Finalfight40]

Something like this maybe:

=SUMPRODUCT(--(WEEKDAY(C1:C6)=1))

=1 Sunday
=2 Monday
=3 Tuesday

I'm sure you get the pattern

 

[Finalfight40]

=SUMPRODUCT(--(WEEKDAY(C1:C6, 2)=1))

Actually better to add in this part and that way

=1 is Monday
=2 is Tuesday and so on