# Increasing cell by 1 each day.

#### WombDweller

##### New Member
Hello master gurus. I have a question for everyone.

I have an Excel spreadsheet with a list of 2000 friends from a site I like. in each row, I have facts about each friend. One of these facts is how long the friend has been a member of the site.

The problem is: After I enter how long the friend has been a member of the site, the number does not increase every day.

Example: Carl friend for 167

I want to see the 167 increase by 1 every day.

This way, every time I look at my excel spread sheet, I see exactly how long Carl has been a friend at the site.

Hope I explained it correctly.

Thanks for your support & suggestions.

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### Michael M

##### Well-known Member
Hi and Welcome to the Board.
Assuming the "start" dates are in cell A1.
If so, insert another column next to it and put in the formula
Code:
``=TODAY()-A1``

Copy down as far as required

#### WombDweller

##### New Member
I tried that but no go.

Actually the number 167 is in cell J1

Tomorrow, I want the cell to read 168

Thanks for everyones support

#### Michael M

##### Well-known Member
How did you get the 167 in J1 ?
Was it a manual entry or date based ?
My formula will work if A1 is the start date

#### Weaver

##### Well-known Member
Rather than the no. of days of membership, is it possible for your data to contain the join date instead? That would make more sense and make calculations easier.

#### WombDweller

##### New Member
Manual base entry. Everything in the spreadsheet so far is manual entry.

I just need the days the member has been on site, to increase each day.

#### Michael M

##### Well-known Member
Ok, as my first post suggested, and Weavers comment...have a join date somewhere on the rowt as part of the friends details.
Then the No of days can be easily calculated using the today function.

#### WombDweller

##### New Member
well here is the thing. I goto the friends page at the site. It says the friend as been on for 165 days. It would take me a long time to figure out what date that was. and to do that for 2000 friends. WOW, I go nuts.lol

No easier way?

#### gsbelbin

##### Active Member
Create a new column for join date and enter = today() - A3 , assuming A3 holds the number of days they have been a friend. Then copy down for all rows. Then copy and paste these values on top of themselves. Then enter Michael M's formula in A3.

HTH

#### Michael M

##### Well-known Member
The copy and paste mentioned in gsBelbins post is...
after you have applied his / her formula
Select the column of data
Edit / Copy
Edit / Paste Special / Values Only
then apply my formula

Replies
4
Views
263
Replies
17
Views
397
Replies
7
Views
414
Replies
5
Views
475
Replies
35
Views
2K

1,181,897
Messages
5,932,682
Members
436,850
Latest member
Jasperlee93

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back