+ Reply to Thread
Results 1 to 6 of 6

Counting cells that contain specific text (date)

  1. #1
    Registered User
    Join Date
    08-24-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2013
    Posts
    55

    Counting cells that contain specific text (date)

    Anyone know a formula for counting the number of cells that contain a specific text?

    Here, I am trying to count the number of cells that contain today's date. I have a spreadsheet with a bunch of accounts that have a note next to each account. The note cell is dated as of a certain date...for example, the note cell may say something like "called and left a VM - 10/3/16"

    How do I write a formula that counts the number of cells that contain today's date, or any date for that matter?

    I keep trying to use the COUNTIF formula and I can't figure it out...please advise...thx!

    Dominick

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Counting cells that contain specific text (date)

    Something like this will work if the dates are all in the same format:

    =COUNTIF(A:A,"*10/3/16*")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Counting cells that contain specific text (date)

    If you have true dates in A1:A40 use to get the number of cells that is equal to today's date
    =COUNTIF(A1:A40,TODAY())

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,901

    Re: Counting cells that contain specific text (date)

    Dominick
    Give this a try:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-24-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2013
    Posts
    55

    Re: Counting cells that contain specific text (date)

    Quote Originally Posted by Tony Valko View Post
    Something like this will work if the dates are all in the same format:

    =COUNTIF(A:A,"*10/3/16*")
    Awesome! That worked.

    If I may ask, any idea why the two asterisks worked, but the formula doesn't work without them? Also, is there a way to tweak the formula to use the TODAY formula so the spreadsheet updates each day?

    Thanks again!

    Dominick

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    Re: Counting cells that contain specific text (date)

    If I may ask, any idea why the two asterisks worked, but the formula doesn't work without them? Also, is there a way to tweak the formula to use the TODAY formula so the spreadsheet updates each day?
    Tony might have some other ideas, but...

    The asterisks are working as wildcards. Since your date is really text inside a cell, the asterisks say no what what come before or what comes after, find 10/3/16 and count how many times it is being used.

    I'm thinking if you want to use today's date, maybe try...

    =COUNTIF(A:A,"*"&TEXT(TODAY(),"mm/d/yy")&"*")
    HTH
    Regards, Jeff

+ 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. Replies: 6
    Last Post: 03-02-2016, 10:41 AM
  2. [SOLVED] Counting Instances where 3 or more concurrent cells containing specific text
    By DaveBre in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-07-2015, 06:00 AM
  3. Replies: 5
    Last Post: 05-04-2015, 04:36 PM
  4. Counting Cells with Specific Text and Font Color
    By omeng414 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-29-2014, 05:03 AM
  5. [SOLVED] Counting Specific Text Occurences in Cells Adjacent to Particular Values
    By lowlybroker in forum Excel General
    Replies: 7
    Last Post: 10-21-2013, 12:07 PM
  6. Counting unique text cells from muliple specific columns?
    By eliopaulos in forum Excel General
    Replies: 21
    Last Post: 08-17-2010, 06:56 AM
  7. Counting cells not containing specific text
    By ddbruno@gmail.com in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-09-2006, 03:30 PM

Tags for this Thread

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