Counting # of days entered in column

[bucci35]

Hello,
I have the following formula in a cell
COUNTIFS($I$7:I1002,">=4/1/24",$I$7:I1002,"<=4/30/24")
It counts the # of entries between the the 2 dates. I want to be able to create a spinner with beginning date and another with ending date to fill this formula however I can't get it to work at all. Any help would be much appreicated!

Dan

 

[awoohaw]

Not sure what you mean by a spinner. Is the date in column I a date value or a text string?

but try this if it is a date:
=COUNTIFS($I$7:I1002,">="&DATE(2024,4,1),$I$7:I1002,"<="&DATE(2024,4,30))

 

[bucci35]

Perfect thank you so much, works great!

 

[awoohaw]

My pleasure, Best wishes!