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

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

2. ## Re: Count the number of Mondays, Tuesdays, etc. within a range of dates.

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

3. ## Re: Count the number of Mondays, Tuesdays, etc. within a range of dates.

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

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1