EDATE function returns a date for a specified number of months from specified
date. Lookup in Help for more info on the function. Note can use positive or
negative months for months ahead or before specified date.


--
Regards,

OssieMac


"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