If you have the analysis toolpack add-in installed:
A1: your date
B1: =EDATE(A1,18)

If not
B1: =DATE(YEAR(A1),MONTH(A1)+18,DAY(A1))

The advantage of the EDATE function is if your day of the month is the 31st,
and 18 months later is not a 31 day month, it will return the end of month
for 18 months later. i.e: A1=08/31/08 then B1=02/28/10
OPT1: A1=08/31/08 then B1=02/28/10
OPT2: A1=08/31/08 then B1=03/03/10

Hope this helps!
--
John C


"cdcam" wrote:

need to add 18 months to a date