Trouble with counting dates

aristotleistimmy

New Member
Joined
Jan 18, 2012
Messages
12
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
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

BobUmlas

Well-known Member
Joined
Mar 14, 2002
Messages
1,170
=SUMPRODUCT(N(A1:A100>=D1),N(A1:A100<=D2))
where D1 is earlier date & D2 is later date.
 

aristotleistimmy

New Member
Joined
Jan 18, 2012
Messages
12
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

New Member
Joined
Jan 18, 2012
Messages
12
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,041
Messages
5,526,417
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top