Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |