plus 6 months
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
|