Hi Debbie

=DATE(YEAR(J2);MONTH(J2)+18;DAY(J2))

With J2 = DOB

Note that my locale use ";" instead of ",". You might have to change this.

Wkr,

JP

"Debbie" wrote in message
...
If DOB is in a1; how would you add 18 months to that DOB?
Thanks!