How to have Excel automatic input the date.

**iamjona** · 04-22-2010, 03:16 AM

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** · 04-22-2010, 03:22 AM

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

**arthurbr** · 04-22-2010, 03:40 AM

Or simply a3=a2+1 ?

**zbor** · 04-22-2010, 03:44 AM

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

**elmarko123** · 04-22-2010, 04:01 AM

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.