Thread: Adding Daily
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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!