=DATE(YEAR(A1), MONTH(A1)+6, DAY(A1))

Where you date is in cell A1
--
HTH...

Jim Thomlinson


"Eclaires" wrote:

Please can someone help, I need a formula to calculate a date 6 months
forward from another date and return the future date as the answer in a cell.
ie: start date 27/01/2010 answer will be 27/07/2010.

Any help would be much appreciated.

Thanks in advance


Viv