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!
|