add one daily

C

caricc

how to add one to a number so it will go up in value daily?

ie: 561 ( as of 12/29/05) need to add one so to day it will read 588 today.
Then 589 tomorrow...

Thanks in advance...
 
E

Echo S

caricc said:
how to add one to a number so it will go up in value daily?

ie: 561 ( as of 12/29/05) need to add one so to day it will read 588
today.
Then 589 tomorrow...
Click to expand...

Which application?
 
B

Bob I

Basically you use the serial number for the day minus whatever value it
takes to get it down to what value you want.
example:
format the cell as number and plug in "=TODAY()-38153" as the expression
 
Top