The formula below is required Analysis TookPak add-in

=EDATE(A1,5)-1


"Sunayan Sanatani" wrote:

1.I have simple dates in one column (say column A) .
2.In the next column(Column B) I would like the date five months after
Column A to be displayed.Eg if Column A has an entry of 9th June
2007,Column B should display 8th November,2007.
3.A simple formula does not do the job as this does not take into
account the different number of days in different months!

regards

S.Sanatani