But keep in mind the short months such as Feb if it is your intention to
always have the day the same. For instance, if the start date is 11/30/06,
the formula will produce 3/2/07 instead of 2/30/07 since there is no 2/30/07.
--
Y
"Bernard Liengme" wrote:
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