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
