Automatic incrementing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marvin Bordelon - 14 Dec 2004 22:17 GMT

I am using Office 2002. I would like to make the first column of a
spreadsheet ,a date field, automatically increment to the next date on each
row. Any ideas how I can do this?

Reply to this Message

Dave Peterson - 15 Dec 2004 00:26 GMT

Put the date in A1 and put
=A1+1
in A2

And drag down.

You could even hide it until you put something in column B.

=if(b2="","",a1+1)

> I am using Office 2002. I would like to make the first column of a
> spreadsheet ,a date field, automatically increment to the next date on each
> row. Any ideas how I can do this?

Signature

Dave Peterson

Reply to this Message