Adding Daily

  • Thread starter Thread starter Jess
  • Start date Start date
J

Jess

I know I have asked this question before, but it is still not working for me!!
I really need to know how to input a formula, so that everyday, without me
having to manually change the numbers, the numbers will increase by 1.

The formula =desirednumber+TODAY()-39781 was working for me for a little
while, but when I tried to input new numbers into my spreadsheet, the formula
automatically added eleven! Is there any way of calculating the excel date to
change that at all?
I need to know this formula.
Thanks!
 
Is desirednumber a named value or range, or are you just using it as a
placeholder here?
Since what day would you like to have been adding 1?
 
In this case I am wanting to update the number of days one of our units has
been at the dealership. If I was just wanting to input a new number today,
what number would I use?
Is there a formula I can use to figure out what number would correspond with
the date at the time?
 
In that case, hopefully you have the purchase date of the unit in another
cell and 'days at dealership' is a separte column.
If your columns were
A: Unit Number
B: Unit Model
C: Purchase Date
D: Days at Dealership

If this particular unit was on row 2 of your spreadhsheet, in column D you
would put

=today()-C2

and format the result as a number.
 
As 39781 was 29th November this year, you are probably better replacing your
=desirednumber+TODAY()-39781
by
=desirednumber+TODAY()-DATE(2008,12,11) if you are starting on December
11th,
or by
=desirednumber+TODAY()-A1 if you want to put your base date in A1.
 
Back
Top