automatically change a number daily

  • Thread starter Thread starter gary
  • Start date Start date
G

gary

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.
 
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
 
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
 
Back
Top