Hi
Try,
place this formula in B2
=DATE(YEAR(A2)+LEFT($B$1,2),MONTH(A2),DAY(A2))

and place this formula in C2
=IF(B2$C$1,"outside 10 yrs,","within10yrs")

make sure that your date in C1 is real date, otherwise its won't works
To format it to real date, right click Format Cells select date
choose mmm-yy
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Jason K" wrote:

I asked a question earlier with two parts. I figured out the date format. But
I am still having trouble adding 10 years to the date and having a column
show if it is within 10 years or outside 10 years from current date.

Eff. Date 10yr as 5/09
08/16/1997 ???? outside 10y
12/10/2001 ???? within 10y