Hi,


I'm trying to get something that does the following:

If A1 contains text "ACTIVE" and B1 contains a date greater than two years ago and C1 contains "0" then D1 equals "Move"

Cheers for any help you can give...

I understand this as a date between today and today minus two years (if not replace the > with a <)

I suppose subtracting 24 months from the present date will doto return the dat from

Thus, in D1

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Outstanding stuff, that nailed it, cheers!