Your formula in B2 would be
=DATE(YEAR(A2)+10,MONTH(A2),DAY(A2))
to add 10 years

The formula in C2 would be
=IF(AND(NOW()=A2, NOW()<=B2), "Within 10", "Not Within 10")
--
HTH...

Jim Thomlinson


"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