Current date plus 3 months

[Dohey1]

I am formatting a spreadsheet and want one column to have an effective date and another column to have this date plus three months

So if the firt column entered is September 15, 2005...the next column will populate with December 15, 2005

Is there a way to do this in Excel?

Please help

Thanks

D

 

[al_b_cnu]

Hi, Welcome to the board!

Try
=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))

 

[Dohey1]

Hi, Thank you.

I am happy to be a member

Will this work (or another function) if I reference the initial ceel with the date required

I have tried EDATE and EOMONTH but with little success.

D

 

[Brian from Maui]

I have tried EDATE and EOMONTH but with little success.

D

Does,

=EDATE(A1,3)

work?

 

[Dohey1]

That's what I have been trying but I keep getting the error: #NAME?

Is there something that I am missing

D

 

[fairwinds]

I have tried EDATE and EOMONTH but with little success.

D

Go to Tools - Add-ins and check the box for analysis tool pack.