Hi all

I have made a spreadsheet to try and increase the number of months in a date.

here is my formula (in cell d5).

the date i am trying to increase is in cell d4

=DATE(YEAR(DATEVALUE(TEXT(D4,"dd-mmm-yy"))),MONTH(DATEVALUE(TEXT(D4,"dd-mmm-yy")))+3,DAY(DATEVALUE(TEXT(D4,"dd-mmm-yy"))))

(i had to convert d4 to text other wise it wouldnt work ???)

The problem i have is that if the date in d4 is say 31/12/06, the formula will work fine and increase the date in d5 to 31/03/07..... however if the date in d4 is 31/1/07, the date in d5 becomes 01/05/07 (it should be 30/4/07).

Can anyone either please tell me why excel is incorrectly increasing the number of months (im guessing it has something to do with some months having 30 or 31 days, hence the extra day).. or have a workaround ?

any help would be awesome
cheers