Results 1 to 5 of 5

Using COUNTIF and dates of different formats

Threaded View

  1. #1
    Registered User
    Join Date
    10-06-2011
    Location
    Salt Lake City, UT
    MS-Off Ver
    Excel 2010
    Posts
    78

    Using COUNTIF and dates of different formats

    I have a table with the start time of a tour and the visitor's name. The start time is in m/d/yyyy h:mm:ss AM/PM format. On a separate portion of the spreadsheet I want to count the number of tours given by day. I tried simply using =COUNTIF(Table1[Start Time],G$2) where G2 is a date in m/d/yyyy format, but the count comes up as zero even when there were visitors on that day because each tour has a unique time of day. Is there anyway to use wildcards or something to make the count function properly? See the attached excel file.

    Thanks
    Attached Files Attached Files
    Last edited by perducci; 01-18-2012 at 07:01 PM.

Thread Information

Users Browsing this Thread

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

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