Simple Count if date not working - please help


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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!