Excel 2007 : Progressive dates

I want the dates in A2:A4 to be 10, 20, and 30 days after the date in A1...

..............A................B
1 11/06/2011
2 21/06/2011...........10
3 01/07/2011...........20
4 11/07/2011...........30

I am using a clumsy way of doing it:

1. Put the relevant no. of days (10, 20, 30) in cells B2:B4

2. In cell A2 insert the formula
=DATE(YEAR(DATEVALUE("11/6/11")),MONTH(DATEVALUE(
"11/6/11")),DAY(DATEVALUE("11/6/11"))+$B2)

3. In cell A3 insert the formula
=DATE(YEAR(DATEVALUE("11/6/11")),MONTH(DATEVALUE(
"11/6/11")),DAY(DATEVALUE("11/6/11"))+$B3)

4. In cell A4 insert the formula
=DATE(YEAR(DATEVALUE("11/6/11")),MONTH(DATEVALUE(
"11/6/11")),DAY(DATEVALUE("11/6/11"))+$B4)

Anyone able to help so that I don't have to add the extra (and unwanted) column B to the worksheet please

Thank you
Syd

Hi,

1. Place your date 11/06/2011 in cell A1.

2. Add this formula to cell A2

Please Login or Register  to view this content.

3. Autofill A2 down to A4.

Cheers,

A2 = A1 + 10
Then fill down.

Is it what you need?

Thank you -- Syd