Gary''s Student Wrote:
If A1 =TODAY()
then =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
puts you 1 month later


..but of course if today is 31st january 2006

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

gives you 3rd March 2006


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