# Date + months

#### slsimon

##### New Member
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

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
=datedif(A1,18,"m")

Should do what you need.

HTH
Cal

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!".

slsimon said:
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().

Replies
3
Views
125
Replies
6
Views
183
Replies
6
Views
245
Replies
4
Views
230
Replies
1
Views
191

1,216,411
Messages
6,130,432
Members
449,581
Latest member
econtent2

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back