On Fri, 3 Jul 2009 02:50:01 -0700, basilio
wrote:

I believe the best function to use in your case is <DATE
when you want to go ahead by 6 months from the date ie 25/3/2009 (eu format)
located in cell say..B1, try " =date(Year(B1);Month(B1)+6;Day(B1)).
this will get you exactly to the same month day and 6 months ahead. Same is
valid when going backwards .
--
Basilio

Not really. You still have the long month issue, just turned around
differently.

For example, using your formula,

28-Aug-2009 -- 28-Feb-2010
29-Aug-2009 -- 1-Mar-2010
30-Aug-2009 -- 2-Mar-2010

An alternative, using the DATE function, would be:

=MIN(DATE(YEAR(B1),MONTH(B1)+6+{1,0},DAY(B1)*{0,1} ))

This does the same as the EDATE function:

28-Aug-2009 -- 28-Feb-2010
29-Aug-2009 -- 28-Feb-2010
30-Aug-2009 -- 28-Feb-2010

I believe most people would accept the latter rather than the former, but
whoever is using the data needs to understand that "month" is an imprecise
term.
--ron