Add A Day Counter

E

EisPanzer

I would like to know if it is possible to add a day counter

I'm using Excel to manage Players from an Online Game called Hattrick, I
want to use the database to store skills, Ages, Wages, Etc, that is OK

But the problem is I want to store as well how many days that the players
are on my team, so, I don't want to have the trouble to update the "days in
club" for the all squad manually, so, Is there a way to add a number for
every day in a cell for every player?

Thank you in Advance
 
A

AKphidelt

you'll need to use two columns, in one column enter the date the player
started.

The other column enter the formula =TODAY()-'Date Started Cell'

Copy and paste that all the way down... and make sure to change the column
format to 'General'.

Lmk if this works.
 
E

EisPanzer

I was not able to add the formul, it appears #name?

What may I be doing wrongly?
 
E

EisPanzer

I figured it out, it's working now, thank you

AKphidelt said:
you'll need to use two columns, in one column enter the date the player
started.

The other column enter the formula =TODAY()-'Date Started Cell'

Copy and paste that all the way down... and make sure to change the column
format to 'General'.

Lmk if this works.
Click to expand...
 
Top