Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Adding Daily
Hello, I am just wondering if it is possible to make it so that the numbers
in my spreadsheet increase by 1 everyday, without me having to go in and manually change them everyday, as this is tedious. Any Help Here? (I am not sure which version it is, but its either 2007 or 2008) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Adding Daily
Hi,
Is that every number in every cell in every worksheet in your workbook or just some of them? Mike "Jess" wrote: Hello, I am just wondering if it is possible to make it so that the numbers in my spreadsheet increase by 1 everyday, without me having to go in and manually change them everyday, as this is tedious. Any Help Here? (I am not sure which version it is, but its either 2007 or 2008) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Adding Daily
Hi,
For one cell this seems reasonable, but for an entire spreadsheet? 1. Say it was one cell, A1, and the current value as of today is 200 replace the value 200 with the formula =200+TODAY()-39781 Starting tomorrow this cell will increase by 1 each day. Its only going to be automatic if you use a formula or write code. If this helps, please click the Yes button Cheers, Shane Devenshire "Jess" wrote: Hello, I am just wondering if it is possible to make it so that the numbers in my spreadsheet increase by 1 everyday, without me having to go in and manually change them everyday, as this is tedious. Any Help Here? (I am not sure which version it is, but its either 2007 or 2008) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Adding Daily
It is for one column of cells going down the page...
"Mike H" wrote: Hi, Is that every number in every cell in every worksheet in your workbook or just some of them? Mike "Jess" wrote: Hello, I am just wondering if it is possible to make it so that the numbers in my spreadsheet increase by 1 everyday, without me having to go in and manually change them everyday, as this is tedious. Any Help Here? (I am not sure which version it is, but its either 2007 or 2008) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Adding Daily
This helps a bunch, but as I am really new at excel, I really don't know
where to begin. Say it says 751. I want it to change daily, without me even having to open the document... Will this work? And can you guide me through the process a little more thoroughly? As if I was a two year old. lol Thanks again for such a quick response! "Shane Devenshire" wrote: Hi, For one cell this seems reasonable, but for an entire spreadsheet? 1. Say it was one cell, A1, and the current value as of today is 200 replace the value 200 with the formula =200+TODAY()-39781 Starting tomorrow this cell will increase by 1 each day. Its only going to be automatic if you use a formula or write code. If this helps, please click the Yes button Cheers, Shane Devenshire "Jess" wrote: Hello, I am just wondering if it is possible to make it so that the numbers in my spreadsheet increase by 1 everyday, without me having to go in and manually change them everyday, as this is tedious. Any Help Here? (I am not sure which version it is, but its either 2007 or 2008) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Adding Daily
I also did your example, and all the shows up on my spreadsheet is:
18/07/1900 what does this mean? "Shane Devenshire" wrote: Hi, For one cell this seems reasonable, but for an entire spreadsheet? 1. Say it was one cell, A1, and the current value as of today is 200 replace the value 200 with the formula =200+TODAY()-39781 Starting tomorrow this cell will increase by 1 each day. Its only going to be automatic if you use a formula or write code. If this helps, please click the Yes button Cheers, Shane Devenshire "Jess" wrote: Hello, I am just wondering if it is possible to make it so that the numbers in my spreadsheet increase by 1 everyday, without me having to go in and manually change them everyday, as this is tedious. Any Help Here? (I am not sure which version it is, but its either 2007 or 2008) |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Adding Daily
Hi,
First it won't change while the document is closed, but when you open the document in 5 days it will adjust by 5, if that's what you want. Suppose the number you want to automatically change is 751 and it is in cell A1 replace the entry in cell A1 with the formula =751+TODAY()-39781 39781 is todays date as a number. It will remain fixed. The TODAY() function returns todays date, in this case as a number. But today is dynamic, tomorrow it will return tomorrows date. Each day is 1 greater than the prior in Excel's date storage method. So tomorrow the TODAY will return 39782 and when you subtract 39781 from it you get 1. So =781+1. Each day TODAY() is one greater but your starting date remains fixed at 39781. If this helps, please click the Yes button. Cheers, Shane Devenshire "Jess" wrote: This helps a bunch, but as I am really new at excel, I really don't know where to begin. Say it says 751. I want it to change daily, without me even having to open the document... Will this work? And can you guide me through the process a little more thoroughly? As if I was a two year old. lol Thanks again for such a quick response! "Shane Devenshire" wrote: Hi, For one cell this seems reasonable, but for an entire spreadsheet? 1. Say it was one cell, A1, and the current value as of today is 200 replace the value 200 with the formula =200+TODAY()-39781 Starting tomorrow this cell will increase by 1 each day. Its only going to be automatic if you use a formula or write code. If this helps, please click the Yes button Cheers, Shane Devenshire "Jess" wrote: Hello, I am just wondering if it is possible to make it so that the numbers in my spreadsheet increase by 1 everyday, without me having to go in and manually change them everyday, as this is tedious. Any Help Here? (I am not sure which version it is, but its either 2007 or 2008) |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Adding Daily
The formula suggested was =200+TODAY()-39781 if the value today was 200.
Can you not work out what to do with the formula if the value today is 751? Format the cell as General (or as number with no decimal places). -- David Biddulph "Jess" wrote in message ... This helps a bunch, but as I am really new at excel, I really don't know where to begin. Say it says 751. I want it to change daily, without me even having to open the document... Will this work? And can you guide me through the process a little more thoroughly? As if I was a two year old. lol Thanks again for such a quick response! "Shane Devenshire" wrote: Hi, For one cell this seems reasonable, but for an entire spreadsheet? 1. Say it was one cell, A1, and the current value as of today is 200 replace the value 200 with the formula =200+TODAY()-39781 Starting tomorrow this cell will increase by 1 each day. Its only going to be automatic if you use a formula or write code. If this helps, please click the Yes button Cheers, Shane Devenshire "Jess" wrote: Hello, I am just wondering if it is possible to make it so that the numbers in my spreadsheet increase by 1 everyday, without me having to go in and manually change them everyday, as this is tedious. Any Help Here? (I am not sure which version it is, but its either 2007 or 2008) |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Adding Daily
WHen I do this, will it show me the original number that I wanted? Say if I
need to print it out on any given day, would it show up as 756 5 days from now? "Shane Devenshire" wrote: Hi, First it won't change while the document is closed, but when you open the document in 5 days it will adjust by 5, if that's what you want. Suppose the number you want to automatically change is 751 and it is in cell A1 replace the entry in cell A1 with the formula =751+TODAY()-39781 39781 is todays date as a number. It will remain fixed. The TODAY() function returns todays date, in this case as a number. But today is dynamic, tomorrow it will return tomorrows date. Each day is 1 greater than the prior in Excel's date storage method. So tomorrow the TODAY will return 39782 and when you subtract 39781 from it you get 1. So =781+1. Each day TODAY() is one greater but your starting date remains fixed at 39781. If this helps, please click the Yes button. Cheers, Shane Devenshire "Jess" wrote: This helps a bunch, but as I am really new at excel, I really don't know where to begin. Say it says 751. I want it to change daily, without me even having to open the document... Will this work? And can you guide me through the process a little more thoroughly? As if I was a two year old. lol Thanks again for such a quick response! "Shane Devenshire" wrote: Hi, For one cell this seems reasonable, but for an entire spreadsheet? 1. Say it was one cell, A1, and the current value as of today is 200 replace the value 200 with the formula =200+TODAY()-39781 Starting tomorrow this cell will increase by 1 each day. Its only going to be automatic if you use a formula or write code. If this helps, please click the Yes button Cheers, Shane Devenshire "Jess" wrote: Hello, I am just wondering if it is possible to make it so that the numbers in my spreadsheet increase by 1 everyday, without me having to go in and manually change them everyday, as this is tedious. Any Help Here? (I am not sure which version it is, but its either 2007 or 2008) |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Adding Daily
As I said, I am new to excel and not really sure about the numbers you are
telling me, you don't have to be so rude about it... "David Biddulph" wrote: The formula suggested was =200+TODAY()-39781 if the value today was 200. Can you not work out what to do with the formula if the value today is 751? Format the cell as General (or as number with no decimal places). -- David Biddulph "Jess" wrote in message ... This helps a bunch, but as I am really new at excel, I really don't know where to begin. Say it says 751. I want it to change daily, without me even having to open the document... Will this work? And can you guide me through the process a little more thoroughly? As if I was a two year old. lol Thanks again for such a quick response! "Shane Devenshire" wrote: Hi, For one cell this seems reasonable, but for an entire spreadsheet? 1. Say it was one cell, A1, and the current value as of today is 200 replace the value 200 with the formula =200+TODAY()-39781 Starting tomorrow this cell will increase by 1 each day. Its only going to be automatic if you use a formula or write code. If this helps, please click the Yes button Cheers, Shane Devenshire "Jess" wrote: Hello, I am just wondering if it is possible to make it so that the numbers in my spreadsheet increase by 1 everyday, without me having to go in and manually change them everyday, as this is tedious. Any Help Here? (I am not sure which version it is, but its either 2007 or 2008) |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Adding Daily
Jess,
Format the cell for general to show 200. 18/07/1900 is the 200nd day of Excel's date system, where each day since Dec 31, 1899 counts as 1. (That is why today is 39781.) When you entered your formual, Excel saw that you had a date function, and automatically formatted the cell as a date. For any number, use a formula like =NumberDesired +TODAY()-39781 So, to get 751 today, and 752 tomorrow, use =751+TODAY()-39781 HTH, Bernie, MS Excel MVP "Jess" wrote in message ... I also did your example, and all the shows up on my spreadsheet is: 18/07/1900 what does this mean? "Shane Devenshire" wrote: Hi, For one cell this seems reasonable, but for an entire spreadsheet? 1. Say it was one cell, A1, and the current value as of today is 200 replace the value 200 with the formula =200+TODAY()-39781 Starting tomorrow this cell will increase by 1 each day. Its only going to be automatic if you use a formula or write code. If this helps, please click the Yes button Cheers, Shane Devenshire "Jess" wrote: Hello, I am just wondering if it is possible to make it so that the numbers in my spreadsheet increase by 1 everyday, without me having to go in and manually change them everyday, as this is tedious. Any Help Here? (I am not sure which version it is, but its either 2007 or 2008) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET | Excel Discussion (Misc queries) | |||
Automatic Adding | New Users to Excel | |||
Adding daily updates without re-doing everything | Excel Discussion (Misc queries) | |||
Please help with adding automatic data. | Excel Discussion (Misc queries) | |||
Adding percentages in a column and automatic formating of contents | Excel Worksheet Functions |