If formula to check greater than today date

[nr6281]

=IF(AL2="",AND(OR(AD2="Coffee",AD2="Tea",AD2="Soap",AD2="Milk"),YEAR(AE2)>TODAY()))

Hi,

Can someone help me correct the above formula?

AL: Column has words and blanks from inventory (Blanks remaining inventory, filled are sold)
AD= Is the product we have
AE= Date

So if the AL column is blank and any of the product in AD matching the formula above is older than the date for the day (Today) should come as true.

 

[Fluff]

Maybe
=IF(AND(AL2="",OR(AD2="Coffee",AD2="Tea",AD2="Soap",AD2="Milk")),IF(AE2>TODAY(),TRUE))

 

[nr6281]

HI,

Just a small change in this I want to capture dates that are over 7 years from the product date is that possible?

 

[MARK858]

What cell is the date you want to "capture" in? and do you mean dates 7 years after the product date or before?

 

[nr6281]

Cell AE2 Has the date

 

[MARK858]

I thought AE2 had the product date? where is the date that is being checked 7 years from the product date (or if AE2 isn't the product date where is the product date?).

Also you haven't answered the other question.

 

[nr6281]

Yes you are correct AE2 has the product date and there is date that is being checked 7 years is at AD2

 

[Fluff]

But in your OP AD2 holds Tea, Coffee etc