=DATE(YEAR(A1),MONTH(A1)+4,DAY(A1))
--
David Biddulph

"Phxlatinoboi®" wrote in message
...
I have a speadsheet that I enter the Date of Hire of an employee. I would
like to have a formula that will calculate in a cell when someone would be
with the company for 4 months.

for example

A1 B1
04/01/07 08/01/07