Easy formula request

[Quinton]

Hello, simple one for you (clearly not me!).

Column A Row 1 has a date of 14-05-11
I would like Column B row 1 to show 14-08-11

Basically it counts 3 months ahead.

Formula explained in simple terms - If column A, Row 1 shows a date of 14-05-11 then please show 14-08-11 in column 2, Row 1.

Many thanks in advance for your help

 

[VoG]

Try

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

 

[Quinton]

Perfect Thanks!

ps have a drink on me!