I am trying to count cells on a separate sheet based on Type in this case its "Hardware" and date range. In this case between 10/7/2012 and 10/24/2012. Looking at my spreadsheet I have two items that match this criteria. However, when I run the formula the counts are 0

=COUNTIFS(AirCheck!C:C, "Hardware", AirCheck!G:G,"<=10/17/2012", AirCheck!G:G, ">=10/24/2012")