I have a set of dates on one sheet. My condensed report sheet needs to count the number of items meeting 2 criteria. One is time less that 14 hours and the second would be created date of cell B2. This will be run daily and it needs to grab that date. The date in B2 now is 2/3/2014 formatted as such. The dates on the other sheet I am pulling data from are date and time cells. formatted as "m/d/yyyy h:mm AM/PM". Is there a way to check those cells for only the date portion of the date and time?