|re: "if its within 4 years since the date in A2"|
By its I assume you mean today's date. If so...
Take a look at the EDATE function.
EDATE returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date).
e.g. For your 5 year (60 months) expiration criteria, this should work.
Basically what this says is "If I add 60 months to the date in A2 and the result is less than today's date, then the date in A2 must be more than 5 years ago."
The "inverse" of that is to subtract 60 months from today's date to get the same result:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03