CountIF Between 2 Dates

**cakonopka** · 05-13-2007, 04:40 PM

Hi All

I need a formula that will count the number of dates within a column that are between 2 cells both with a date in each?

Many Thanks

Chris

**VBA Noob** · 05-13-2007, 05:01 PM

Try Sumproduct

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

VBA Noob

**cakonopka** · 05-14-2007, 11:50 AM

I have read all through the link u gave, som,e real useful data on there, but it doesent actually state how to use the sum product formula to check a list of data for dates between 2 specific dates in cell references, it has hjow to check each specified data entered but would be a huge formula and would need changing every day, not ideal.

Any More Ideas

Chris

**NBVC** · 05-14-2007, 11:55 AM

Something like:

=Sumproduct(--(date_range>=Date1),--(date_range<=Date2),--(data_range=criteria))

where date_range is range containing dates to search between Date1 & Date2
data_range is range containing data to search criteria

**cakonopka** · 05-14-2007, 12:10 PM

That looks Good, Just what im looking for, although i have entered the following formula:

=SUMPRODUCT(--(date_range>=B174),--(date_range<=B175),--(datarange=D:10:D149)

Gettin #NAME come up, Cells B174 and B175 have the 2 dates in

Any Ideas?

Chris

**NBVC** · 05-14-2007, 12:14 PM

You have to replace date_range and data_range with actual ranges containing the data , eg. A10:A149, unless you named your ranges?

Also, the last argument in your formula references a range incorrectly

--(datarange=D:10:D149) should be perhaps --(datarange=D10:D149)

**cakonopka** · 05-14-2007, 12:21 PM

ok, Have changed formula to the below but still get #NAME

=SUMPRODUCT(--(D10:D149>=B174),--(D10:D149<=B175),--(Datarange=D10:D149))

Any more ideas, or am i just missin soemthing?

Chris