automatically change a number daily
 

hi

i would like to be able for my excel worksheet to change a nuber every day
for instance i would like a say sales after day 8 to change to day 9 the next
day, is there a way i can do this.
--
thanks

gary

automatically change a number daily
 

Hi Gary,
You would have to define your Day-1 date.
Lets say Day-1 is 1/1/2008
If Cell A1 is to show the current day number,
then enter the following:
="Day "&ABS(DATE(2008,1,1)-TODAY())
Day-1 date in the formula uses the following format:
yyyy,m,d
Regards - Dave

automatically change a number daily
 

If Jan. 1, 2008 is day 1 then you can use: ="Day - " &
TODAY()-DATEVALUE("1/1/2008")+1
Or if you just want to see the number, use =TODAY()-DATEVALUE("1/1/2008")+1
and format the cell as general

Tyro

"gary" wrote in message
...
hi

i would like to be able for my excel worksheet to change a nuber every day
for instance i would like a say sales after day 8 to change to day 9 the
next
day, is there a way i can do this.
--
thanks

gary