Is it possible to apply RoundDown(,) to a range of cells within the CountIfs function?

This code uses the CountIfs function to count up the number of cells on the All Items worksheet in the range Cells(1, DateEscalatedCol) to Cells(100, DateEscalatedCol) that are equal to Cell(1,1) on the Breakdown worksheet.

The problem is that the Cells(1,1) on the Breakdown worksheet is in the format of MM/DD/YYYY and the format of the DateEscalatedCol column on the All Items worksheet is in the format of MM/DD/YY MM:SS. But for the sake of this comparison, I don't care about the MM:SS. So in other words, the comparison that CountIfs is doing won't work the way that I want it to because of the MM:SS.

Is there a way to use the Application.WorksheetFunction.RoundDown(,) function and apply it to the entire range of cells within the CountIfs function?

Please Login or Register  to view this content.

Thanks so much!