if-statement

[Max_power]

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

[Bob Phillips]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[Max_power]

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

[robert111]

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