software

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: www.excelforum.com/member.php...oamp;userid=32255
View this thread: www.excelforum.com/showthread...hreadid=528129You could use a simple countif

=COUNTIF(A1:A101,quot;gt;=quot;amp;B1-30)-COUNTIF(A1:A101,quot;gt;quot;amp;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)

quot;Max_powerquot; gt; wrote
in message ...
gt;
gt; Hello,
gt;
gt; I'm trying to do a VLOOKUP that incorporates dates in the lookup. Is
gt; that possibble. I've got dates like
gt; from
gt; 1/4/04 to 1/5/04
gt; 1/5/04 to 1/6/04
gt; etc......
gt; I want to do an if statement or a lookup that allows to only select
gt; dates that are greater than a certain date. Is this possible?
gt; So if certain products or whatever hasn't been active in say a period
gt; of 3 months to not count them.
gt;
gt; Many thanks for any input
gt;
gt; Max
gt;
gt;
gt; --
gt; Max_power
gt; ------------------------------------------------------------------------
gt; Max_power's Profile:
www.excelforum.com/member.php...oamp;userid=32255
gt; View this thread: www.excelforum.com/showthread...hreadid=528129
gt;

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 quot;aquot; 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: www.excelforum.com/member.php...oamp;userid=32255
View this thread: www.excelforum.com/showthread...hreadid=528129
you could put an extra column in your spreadsheet which tests the date
and returns quot;ignorequot; or quot;usequot;

then just put that criteria in the top left box in the pivot table
layout and set it to quot;usequot;

You will then only analyse the required data--
robert111
------------------------------------------------------------------------
robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
View this thread: www.excelforum.com/showthread...hreadid=528129