you could use this formula to add one year to a date in A1

=date(year(A1)+1,month(A1),day(A1))

for 3 years change the 1 to a 3

or using EDATE from analysis toolpak

=EDATE(A1,12)

for 3 years change the 12 to a 36

note: these might give different answer in some circumstances, e.g. if
A1 is a leap day, e.g. 29th February 2008


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=543454