Increasing cell by 1 each day.

WombDweller

New Member
Joined
Aug 10, 2010
Messages
18
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.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,094
Office Version
2013
Platform
Windows
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
Joined
Aug 10, 2010
Messages
18
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
Joined
Oct 27, 2005
Messages
19,094
Office Version
2013
Platform
Windows
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
Joined
Sep 10, 2008
Messages
5,196

ADVERTISEMENT

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
Joined
Aug 10, 2010
Messages
18
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
Joined
Oct 27, 2005
Messages
19,094
Office Version
2013
Platform
Windows

ADVERTISEMENT

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
Joined
Aug 10, 2010
Messages
18
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
Joined
Aug 29, 2008
Messages
336
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
Joined
Oct 27, 2005
Messages
19,094
Office Version
2013
Platform
Windows
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
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,298
Messages
5,510,474
Members
408,791
Latest member
bwirth

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top