Is there a way to format a cell to show aging?

  • Thread starter Thread starter Carolina Girl
  • Start date Start date
C

Carolina Girl

I am working on a financial spreadsheet and would like to have a column
showing how many days have passed after the date in another column. Is there
any way to do this?
 
On Fri, 7 May 2010 13:18:01 -0700, Carolina Girl <Carolina
I am working on a financial spreadsheet and would like to have a column
showing how many days have passed after the date in another column. Is there
any way to do this?
Click to expand...


You can subtract the data in "another column" from todays date the get
the "age". Use the TODAY() formula like this in cell B1 if "another
column" is column A.

=TODAY()-A1

Hope this helps / Lars-Åke
 
In the cell where you want the number of days to be (we'll use A2 for this),
type in the following:
=TODAY()-A2
Format the cell as General and it will show you how many days.
 
Back
Top