Simple Count if date not working - please help

Nichole Pyle

Hello,

I have a simple count formula that I can't seem to get to work. I'm creating a sheet that summarizes the # of times a specific date appears in a single column located on a separate sheet.

The current formula is showing 0 even though 5/4/20 is listed several times in my reference column.

Current formula: =countif({completed-Successful hires range1}, ISDATE(5/4/20))

The reference column (range 1) is set to a date column.

Thanks for your help

Brian Campbell

Hello,

Try switching isdate(5/4/20) to DATE(2020, 5, 4). What you are doing is asking if 5/4/20 is a date with your current formula I believe.

Hope this helps

Brian Campbell

Hello,

Try switching isdate(5/4/20) to DATE(2020, 5, 4). What you are doing is asking if 5/4/20 is a date with your current formula I believe.

Hope this helps

Nichole Pyle

Thank you so much! It worked 😁