Not sure I quite follow your logic but using the functions DAY(A1)
MONTH(A1) YEAR(A1) you can split a date into it's component parts.
Then use DATE(year,, month, day) to get the new date.
therefore if cell A1 contains 31/Jan/2006 then
=date(year(A1)+11,Month(A1),20) returns 20Jan/2011
regards
--
tony h
------------------------------------------------------------------------
tony h's Profile:
http://www.excelforum.com/member.php...o&userid=21074
View this thread:
http://www.excelforum.com/showthread...hreadid=511020