Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic incrementing
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? |
#2
|
|||
|
|||
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) Marvin Bordelon wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off automatic date formatting? | Excel Discussion (Misc queries) | |||
Automatic backup copy | Charts and Charting in Excel | |||
how do you turn off automatic hyperlink in excel 2003 | Excel Discussion (Misc queries) | |||
automatic font selection | New Users to Excel | |||
Is there an automatic way to change numbers such as 12312001 t | Excel Discussion (Misc queries) |