Unless I've completely misunderstood your requirement, try this:-

=DATE(YEAR(F1),MONTH(F1)+10,DAY(F1))

Mike

"Shaggyjh" wrote:

Hi,

I have searched but can't see this specific question.

Basically the question is how to add moths to a date, i need to have a
column that has column F's dates + 10 months. However, the column F dates
are all month end days, so 31/8/07 or 28/02/06 or 30/06/07.

I have tried the edate function and also tried date(year(f),month(f)+10,
day(f)) formula, but both gives 28/12/07 if the figure in the original column
was February.

Is there a way of rounding the date up or down to the last day of the month?

Many thanks