Trouble with counting dates

[aristotleistimmy]

I am back-tracking and need to count the amount of items that fall within a certain date range.

my dates are set up in a month/day/year format.

I don't know how to use the countif command that well if that's even the easiest way. I'm sure you guys know an easier way.

I know there's an easy way to do it but I'm just such a noob.


Thanks

 

[BobUmlas]

=SUMPRODUCT(N(A1:A100>=D1),N(A1:A100<=D2))
where D1 is earlier date & D2 is later date.

 

[aristotleistimmy]

this makes me so mad. or stupid actually. I'm glad I knew about this forum because I would of spent hours on this. you are my hero. spot on man.

 

[aristotleistimmy]

I'm definitely gonna be back on here soon because I know I can make my job exponentially easier if I knew excel better. thanks