Automatically increase cell value daily

I am looking for a formula that if I enter a number, X, into a column, then tomorrow it will go up by one integer. So by each day that number will increase by one and so on.... I will be using this for a study with stock charts. It has to do with fibonacci numbers and certain stocks will do certain things around certain important fibonacci numbers. Sounds simple yet I have yet to come across this formula.. Thanks in advance btw

Apologies, and appreciate the correction. I have tried to Google the solution and have not had any luck. Perhaps I need to use your suggested title in the google search and maybe that will pull it up

Hi CupN,

Try this:
a. Format a cell as a number with 0 decimal places
b. Enter the following formula in the cell: =TODAY() - DATE(2015,2,15)
c. There should be a single digit number in the cell - probably 2 because today is Feb 17th.
d. Each day the value in the cell will automatically increment by 1.

Lewis

Lewis, Thanks! So I will give this a try. Now, if I wanted to reset the count would I change the "date" to todays date or can I simply enter 1 in the field to restart the counting per say?

Originally Posted by LJMetzger

Hi CupN,

Try this:
a. Format a cell as a number with 0 decimal places
b. Enter the following formula in the cell: =TODAY() - DATE(2015,2,15)
c. There should be a single digit number in the cell - probably 2 because today is Feb 17th.
d. Each day the value in the cell will automatically increment by 1.

Lewis

if I wanted to reset the count would I change the "date" to today's date or can I simply enter 1 in the field to restart the counting per say?

Almost. Today's date (February 18, 2015) is 42053 on my computer, meaning 42053 days since the arbitrary Microsoft day ZERO.

Lewis