I'm trying to do a count in a column based on a specific date.

Paulo Salazar

If I wanted to count the number of cells in column B had the date of 1/22/20, how would I go about doing that? I've tried the following with no luck: =COUNTIF([Customer Account Creation Date]2:[Customer Account Creation Date]70, DATE(20, 1, 22))

Paul Newcome

The year in the DATE function needs to be 4 digits.

=COUNTIF([Customer Account Creation Date]2:[Customer Account Creation Date]70, DATE(2020, 1, 22))