Date column formula

Options

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.


Best,


Nelson

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!