I am trying to use COUNTIFS to count the number of records within specified date ranges. I am using the following formula:
=COUNTIFS(Data!$I:$I,">="&B11,Data!$I:$I,"<="&B12)
"I" is the column with the dates
B11 points to the start date, in this case 7/1/2010
B12 points to the end date, in this case 7/31/2010
This formula is returning 176 records, but when I filter column I for July 2010, I receive 179 records.
Any ideas on the problem?
Bookmarks