Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Count by days of the week

    Hi Loungers

    I have a spreadsheet is exported from a Database.

    Column B contains dates in DD/MM/YYYY format (say B1:B300)

    I'm trying to count the number of dates that are a Monday, Tuesday, Wednesday, etc.

    Any help would be appreciated. Hope that makes sense.

    Regards

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Verada,

    This does the trick: =SUMPRODUCT((WEEKDAY(B2:B366)=1)*1)
    verada.JPG

    Note: 1=Sunday, 2=Monday,...7=Saturday.

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    verada (2015-04-29)

Posting Permissions

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