Trying to calculate week start using countif but the calculation seems to be wrong

I'm trying to calculate count of dates using the formula CountIF([date]:[date],"11/25/2019")

Wherever i have the date as 11/25/2019, it should give me the count, it should give me the total count.

But the formula isn't giving any data using this formula



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!