Adding Daily
 

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!

Adding Daily
 

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?

"Jess" wrote:

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!

Adding Daily
 

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?

"~L" wrote:

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?

"Jess" wrote:

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!

Adding Daily
 

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.


"Jess" wrote:

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?

"~L" wrote:

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?

"Jess" wrote:

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!

Adding Daily
 

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.
--
David Biddulph


"Jess" wrote in message
...
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!