=COUNTIFS Specific Dates

adrian.bleivns112656

I am trying to count the number of times a specific schedule date is listed in a column for a sheet, not able to narrow down the formula exactly

adrian.bleivns112656

I tried the following with no luck - =COUNTIFS({MEDCTR-1 Range 1}, "12/02/19").  All I get back is a value of 0 even though I have 64 cells that meet that criteria 

 

Paul Newcome

When referencing dates in a formula, you need to use the DATE function.

 

=DATE(yyyy, mm, dd)

 

=COUNTIFS({MEDCTR-1 Range 1}, @cell = DATE(2019, 12, 02))