Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 97 SR-1 / Set date in a cell-have day track in another cell
In Excel 97/SR-1, how can I set a day or date in a cell, and have the other
cell track the other and in another cell, sequentially increment a number ... i.e.: Page 1 Date: 29 September 2005 Day: Thursday Number: 6899 Page 2 Date: 30 September 2005 Day: Friday Number: 6900 Page 3 Date: 01 October 2005 Day: Saturday Number: 6901 Thank you...- |
#2
|
|||
|
|||
You could use a formula that points back to the date.
If Page 2 is a worksheet sheet2 and Page 1 is sheet1, you could use: =sheet1!a1+1 (and format it nicely). To get the day, you could just point at that cell that holds this formula: =A1 and format as dddd For the number, you can just use: =sheet1!A3+1 (Well, if I understood what you were asking.) mgb757 wrote: In Excel 97/SR-1, how can I set a day or date in a cell, and have the other cell track the other and in another cell, sequentially increment a number ... i.e.: Page 1 Date: 29 September 2005 Day: Thursday Number: 6899 Page 2 Date: 30 September 2005 Day: Friday Number: 6900 Page 3 Date: 01 October 2005 Day: Saturday Number: 6901 Thank you...- -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
How do I insert a date created in a cell in excel? | Excel Worksheet Functions | |||
Exporting from MYOB to Excel the date cell doesn't display as dat. | Excel Worksheet Functions | |||
Inserting the date that an excel sheet is saved into a cell | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |