How to have Excel automatic input the date.

[iamjona]

I would like to have my sheet be able to do something like.. let's say If I type 4/19/2010 in A2 I want A3 to be fill with 4/20/2010 automatic and A4 to be 4/21/2010 automatic all the way like this to A29 is it possible?

Thank You

[zbor]

In A3 write =$A$2+ROWS($A$2:A2) and pull down

[arthurbr]

Or simply a3=a2+1 ?

[zbor]

true, but following Donkeyote suggestion: deleting row(s) with that formula will generate error further on will ROWS formula won't

[elmarko123]

Yeah..

What i would do is as the person above said


example


--------a------------------b----------------c-------------
---10/04/10----------= a1 + 1------------ =b1 + 1 I


Then just drag it across as far as you need, simply referencing each cell to look at the one to the left and do a +1 calculation.