Date + months

[slsimon]

What formula do you use to add 18 months to a date? i.e.

Colmn 1 / colmn2
today's date / date 18 months from today

 

[Cbrine]

=datedif(A1,18,"m")

Should do what you need.

HTH
Cal

 

[slsimon]

The 1st column is today's date so the 2nd column should be today's date+18 months but I am coming up with a "#NUM!".

 

[Aladin Akyurek]

What formula do you use to add 18 months to a date? i.e.

Colmn 1 / colmn2
today's date / date 18 months from today

One of:

=EDATE(A1,18)

=DATE(YEAR(A1),MONTH(A1)+18,DAY(A1))

where A1 houses a date, possibly by a formula like =TODAY().