Results 1 to 8 of 8

CountIF for dates

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-11-2016
    Location
    Atlanta
    MS-Off Ver
    2016
    Posts
    104

    CountIF for dates

    I need to count the number of treatments on a certain date (which is the number of times a certain date appears). Attached is a representative sample of my data. I think the problem lies in the fact that the data is in the format "1/3/2017 8:00:48 AM" but only shows in the cell "3-Jan". I'm currently using this formula:

    =COUNTIF($F$3:$F$62, B4)

    So, in the data I want to count how many times 3-Jan appears in Column F. and place this count in column C next to 3-Jan in column B (place count in cell C6). I've got a full year of data so ideally you use reference cells so that I don't have to manually type each date in CountIf Formula.

    Thanks in advance guys,

    Matt
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. COUNTIF using dates
    By bradleyandrewdavis in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-08-2015, 01:45 PM
  2. [SOLVED] COUNTIF with Dates
    By lestergit in forum Excel General
    Replies: 2
    Last Post: 07-19-2011, 02:09 PM
  3. COUNTIF function with Dates & due dates.
    By kcowper in forum Excel General
    Replies: 3
    Last Post: 03-10-2011, 12:51 AM
  4. [SOLVED] Countif using dates
    By Bugaglugs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  5. [SOLVED] Countif using dates
    By Bugaglugs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 PM
  6. Countif using dates
    By Bugaglugs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  7. Countif using dates
    By Bugaglugs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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