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
Bookmarks