Hello!

I'm trying to get a formula to work which will allow me to calculate a date
half a year into the future. I'm using MONTH(D27)+6, where D21 contains a
date. But if I input, say 31.08.2008 here, I get the output 03.03.2009,
instead of 28.02.2009, which is what I'm looking for (the date format I'm
using is DD.MM.YYYY, by the way).

I also tried with YEAR(D27)+0,5, but that doesn't seem to work at all.
YEAR(D27)+1, on the other hand, seems to work perfectly if the duration is
one year.

What do I need to do to make it correct for half a year?


Best regards,
Torfinn