Enter this formula in N3:

=IF(ISNUMBER(M3),DATE(YEAR(M3)+1,MONTH(M3),DAY(M3) ),"")

Biff

"Vivian H." wrote in message
...
I'm using Excel2003 with sp2. I want to track expiration dates of
memberships

I want to say: If m3 is blank make N3 blank and if M3 has a date, make
N3
one year later.

How do I do this?

Thanks in advance,
Vivian