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.
 

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
20,394
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. 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
20,394
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. 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
20,394
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. 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
20,394
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. 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
 

Watch MrExcel Video

Forum statistics

Threads
1,133,325
Messages
5,658,171
Members
418,430
Latest member
Chlwls808

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top