Your post is a bit ambiguous since you don't really say how the
different number of days in months should be handled.

One way:

A1: <date
B1: =DATE(YEAR(A1),MONTH(A1)+5,DAY(A1)-1)



In article ,
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