Dynamic dates

[rdelbell]

Hello,

Can someone help me with a quick question? I am trying to create a cell that will be show the date 3 months later than the previous cell.

Ex.


A1 - 9/1/2011

A2 - 12/1/2011

I would like B1 to equal A1+3 months forward.

I know I can do it by saying =A1+90 because that should be almost exactly 3 months but I'm hoping there is a easier solution as the start date will change for purposes of what i need this chart to do.

Thanks!
rdelbell

 

[VoG]

Try

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

 

[rdelbell]

That worked! Thanks!