Andrew

This is one of the things you can do :-

Use the "edate()" function!

finalDate = edate(yourDate, roundup(yearfrac(yourDate,
yourOtherDate),0)*12)

In your example,

yourDate refers to 5th of June 2004
yourOtherDate refers to 1st of November 2005
finalDate will be 5th of June 2006


Hope this helps!


Best regards



Deepak Agarwal


--
agarwaldvk
------------------------------------------------------------------------
agarwaldvk's Profile: http://www.excelforum.com/member.php...o&userid=11345
View this thread: http://www.excelforum.com/showthread...hreadid=384409