| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I automatically add 1 day to a base number every day?
I need to create a cell in excel where I can take a base number (96) and have
it add (1) every day. So that today it will be 97 and tomorrow it will be 98 and so on. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I automatically add 1 day to a base number every day?
One way:
=TODAY() - DATE(2005,10,18) In article , Shellbie3 wrote: I need to create a cell in excel where I can take a base number (96) and have it add (1) every day. So that today it will be 97 and tomorrow it will be 98 and so on. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I automatically add 1 day to a base number every day?
Thank you. That worked perfect.
"JE McGimpsey" wrote: One way: =TODAY() - DATE(2005,10,18) In article , Shellbie3 wrote: I need to create a cell in excel where I can take a base number (96) and have it add (1) every day. So that today it will be 97 and tomorrow it will be 98 and so on. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to automatically number a new document(Invoice) when opening | Excel Discussion (Misc queries) | |||
| How to automatically number a new document(Invoice) when opening | Excel Discussion (Misc queries) | |||
| XL2000 - How do i change number base? | Excel Discussion (Misc queries) | |||
| How to make Cells automatically become 'highlighted' when number . | Excel Worksheet Functions | |||
| How to make Cells automatically become 'highlighted' when number . | Excel Worksheet Functions | |||
Linear Mode
