=COUNTIFS Specific Dates
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
Comments
-
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
-
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))
