Try =DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))
you may need to format the cell to show a date if you see a number like
39173
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Kimberly" wrote in message
...
Does anyone know how to create a formula that will calculate 3 & 30 months
from any given date?
Date 3 mon 30 mon
Example: 1/1/07----- 4/1/07----- 11/1/08