Hi,

try

=EDATE(A1,6)

This function will return the date 6 months in the future, actually the same
day 6 months in the future.

The function is an ATP one so in 2003 you need to attach it by choosing
Tools, Add-ins and checking Analysis ToolPak.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"lesiofamily" wrote:

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