You could use a simple countif

=COUNTIF(A1:A101,"="&B1-30)-COUNTIF(A1:A101,""&B1)

will count all dates in column A that are 30 days or less previous to a date
in B1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Max_power" wrote
in message ...

Hello,

I'm trying to do a VLOOKUP that incorporates dates in the lookup. Is
that possibble. I've got dates like
from
1/4/04 to 1/5/04
1/5/04 to 1/6/04
etc......
I want to do an if statement or a lookup that allows to only select
dates that are greater than a certain date. Is this possible?
So if certain products or whatever hasn't been active in say a period
of 3 months to not count them.

Many thanks for any input

Max


--
Max_power
------------------------------------------------------------------------
Max_power's Profile:
http://www.excelforum.com/member.php...o&userid=32255
View this thread: http://www.excelforum.com/showthread...hreadid=528129