Date column formula


Hi, I am looking to collect a monthly count per date entry for one of my sheets to display on a dashboard. I created a Metrix to collect this information from the sheet, but I can't figure out what formula to use. Do you have formula I can use for this type of display? I am entering this manually. please see attachment.

I tried using the code below. But it doesn't work.

=COUNT({XXXXXXXXXXXXX}, >=DATE(2020, 2, 1), {XXXXXXXXXXXXX}, <=DATE(2020, 2, 28))

I will appreciate your help on this.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!