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
Bookmarks