+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Forum Contributor Gabor's Avatar
    Join Date
    02-15-2004
    Location
    Székesfehérvár, Hungary
    MS-Off Ver
    xl2016
    Posts
    225

    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
    Regards,

    Gabor

    Protect trees.. maybe one day we need to climb back....

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,520

    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).
    Last edited by CK76; 07-03-2020 at 02:36 PM.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Forum Contributor Gabor's Avatar
    Join Date
    02-15-2004
    Location
    Székesfehérvár, Hungary
    MS-Off Ver
    xl2016
    Posts
    225

    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!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How many Mondays, Tuesdays, etc. to date - AGAIN...
    By OverKnight in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-01-2016, 01:18 PM
  2. Number of Mondays (Tuesdays, etc.) in a month, not counting holidays
    By ratkins in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-24-2015, 04:12 PM
  3. [SOLVED] How many Mondays, Tuesdays, etc. in 2015 to date?
    By OverKnight in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-20-2015, 01:53 PM
  4. Replies: 15
    Last Post: 04-10-2012, 11:34 AM
  5. calculate the number of mondays between 2 given dates
    By Portuga in forum Excel General
    Replies: 3
    Last Post: 03-11-2008, 08:44 PM

Bookmarks

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