I'm trying to do a count in a column based on a specific date.

If I wanted to count the number of cells in column B had the date of 1/22/20, how would I go about doing that? I've tried the following with no luck: =COUNTIF([Customer Account Creation Date]2:[Customer Account Creation Date]70, DATE(20, 1, 22))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!