Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic Adding Daily | Excel Worksheet Functions | |||
HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET | Excel Discussion (Misc queries) | |||
Linking Daily Worksheet To Daily Invoice Total | Excel Worksheet Functions | |||
Adding daily updates without re-doing everything | Excel Discussion (Misc queries) | |||
What Bus. templete do I use for daily cost w/ daily & cum cost ? | Excel Discussion (Misc queries) |