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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sarah" wrote in message ...
|I would like to find a function that will take the date in one column and
| tell me what date is 4 months after that date - any thoughts