+ Reply to Thread
Results 1 to 2 of 2

Count how many cells have the same date

  1. #1
    Registered User
    Join Date
    03-22-2017
    Location
    Tampa, Florida
    MS-Off Ver
    2010
    Posts
    0

    Count how many cells have the same date

    My spreadsheet contains a column with different dates. I would like to count the number of cells that have the same date. Example

    Error Document Rpt Date
    1002916233 3/2/2017
    1002885840 3/2/2017
    1002893652 3/2/2017
    1002890428 3/3/2017
    1002890429 3/2/2017
    1002890430 3/2/2017
    1002915778 3/2/2017
    1002915806 3/2/2017
    1002910218 3/8/2017
    1002910219 3/15/2017
    1002914545 3/15/2017
    1002916840 3/15/2017
    1002906778 3/15/2017

    results would be 3/02/2017 count is 7
    3/03/2017 count is 1
    3/08/2017 count is 1
    3/15/2017 count is 4

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello sjohnso6,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Count how many cells is before a date
    By stan255 in forum Excel General
    Replies: 3
    Last Post: 01-31-2017, 09:52 PM
  2. Count cells with specific date
    By Cookiemonstuh in forum Excel General
    Replies: 5
    Last Post: 11-09-2015, 04:27 PM
  3. Count cells with a date
    By klethag in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-25-2015, 11:30 AM
  4. [SOLVED] count occurrenced of today's date in cells where the date is imbedded in other text
    By ItzikM in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-25-2015, 10:51 PM
  5. Replies: 12
    Last Post: 11-22-2011, 09:27 AM
  6. Count number of cells with date <today's date
    By Cachod1 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-27-2006, 10:40 PM
  7. count the number of cells with a date <= today's date
    By Cachod1 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-27-2006, 05:20 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