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

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

Many many thanks for your reply. It's not quite what I was looking for.
I'll try and become more clear in my intentions.
I've got a pivot table with a lot of data and there are certain items
in the pivot table say that have been inactive over a period of time
So say I have months like
jan - a b c d
feb- b c d e
mar - b c d e
Apr - b c d e
May - b c d e
......
Note that "a" hasn't occured in over 4 months so is there a formula or
something I can use to discard that piece of information from my
worksheet. Also note that I will have multiple instances of this kind
of action so a robust formula will be needed.

Thanks for any help or ideas

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

you could put an extra column in your spreadsheet which tests the date
and returns "ignore" or "use"

then just put that criteria in the top left box in the pivot table
layout and set it to "use"

You will then only analyse the required data


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