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


"Rick Rothstein" wrote:

The only thing you have to be aware of when using EDATE is how it handles
the end of long months to short months 6 months hence. For example, EDATE
will return 2/28/2010 for start dates of 8/28/2009 through 8/31/2009
inclusive.

--
Rick (MVP - Excel)


"lesiofamily" wrote in message
...
is there a function which would calculate new date from a given date?
e.g. column A row 1= 07.03.2009
I would like column B row 1 to show= 01.03.2010 - which is in 6 months
is it possible? any suggestions welcome

thank you

--
lb