ExcelBanter - Add 18 months

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Add 18 months (https://www.excelbanter.com/excel-worksheet-functions/245829-add-18-months.html)

If DOB is in a1; how would you add 18 months to that DOB?
Thanks!

Hi Debbie

=DATE(YEAR(J2);MONTH(J2)+18;DAY(J2))

With J2 = DOB

Note that my locale use ";" instead of ",". You might have to change this.

Wkr,

JP

"Debbie" wrote in message
...
If DOB is in a1; how would you add 18 months to that DOB?
Thanks!

On Oct 18, 10:44*am, "JP Ronse" wrote:
Hi Debbie

=DATE(YEAR(J2);MONTH(J2)+18;DAY(J2))

With J2 = DOB

Note that my locale use ";" instead of ",". You might have to change this..

Wkr,

JP

"Debbie" wrote in message

...

If DOB is in a1; how would you add 18 months to that DOB?
Thanks!- Hide quoted text -

- Show quoted text -

Awesome, thank you! Works great.

Hi Debbie,

The safest formula is:
=MIN(DATE(YEAR(A1),MONTH(A1)+18+{0,1},DAY(A1)*{1,0 }))
With this, if the starting month has more days than the end month, and the start day is on the last day of the month, the returned
date will be the last day of the month that's 18 months hence. For example, if the start date is 31/August/2008, the returned date
would be 28/February/2010.

However, a formula like:
=DATE(YEAR(A1),MONTH(A1)+18,DAY(A1))
is liable to return a date in the following month in such circumstances. For example, if the start date is 31/August/2008, the
returned date would be 3/March/2010.

As barry houdini says, you can use EDATE function, but this requires the Analysis ToolPak to be activated in versions before Excel
2007.

--
Cheers
macropod
[Microsoft MVP - Word]

"Debbie" wrote in message ...
If DOB is in a1; how would you add 18 months to that DOB?
Thanks!