Clarification:

EDATE requires the Analysis ToolPak add-in be installed

For Excel versions prior to Excel 2007.

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this:

=EDATE(A1,6)

Format as Date.

EDATE requires the Analysis ToolPak add-in be installed. If you enter the
formula and get a #NAME? error see help on the EDATE function and it'll
tell how to fix the problem.

--
Biff
Microsoft Excel MVP


"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