Count the number of Mondays, Tuesdays, etc. within a range of dates.

Hi there,
I have dates in col A
I need to make a graph of how many Mondays, Tuesdays .... Sundays are there within col A. A kind of activity split.
What is the cutest way of getting that split by formula?

Thanks

Personally, I'd recommend use of Pivot Table (using dimension table with one to many relationship with the source data) rather than formula.
Edit: Or by adding Helper column to the source data.

If you need formula solution... it would depend on your data structure and criteria.

Is your dates in Col A contiguous series? And sorted? Or is it unsorted list?

If latter... SUMPRODUCT would be a solution...
Ex: For Monday...
=SUMPRODUCT(--(WEEKDAY(A2:A40,2)=1))

If you need further help, I'd recommend uploading sample workbook (follow instruction on the yellow banner at the top).

Hello CK76.
The formula you provided worked me well after minor mods.
Thanks!