HOUR function in a COUNTIF

Originally Posted by Kaper

in U11 you have full date, no hours
so you compare data in columns with 2015-12-15 00:00:00

But even if I change Row 11 to 'dd-mmm-yyyy hh:mm' format it still doesn't seem to work?

U17 still says 1.