COUNTIF DateTime by Date criteria

[zico8]

Hi,

Is it possible to use COUNTIF function to Range with data in DateTime format and Criteria with data in Date format to compare Dates only?

For example:
Range: Cells from A1 to A3:
2019-06-04 18:33
2019-06-05 09:58
2019-06-05 12:33

Criteria in cell C1: 2019-06-05

The expected formula should look like:

=COUNTIF(A1:A3;C1)

but it should to compare date only (without time), result then should be 2.

 

[Marcelo Branco]

Try

=SUMPRODUCT(--(INT(A1:A3)=C1))

M.

 

[Norie]

You could try COUNTIFS.

=COUNTIFS(A1:A3,">="&C3, A1:A3, "<"&C3+1)

 

[zico8]

Thanks a lot guys!

Both solutions work excelence!