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

[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?

 

[David Biddulph]

=TODAY()-A2

 

[Lars-Åke Aspelin]

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?

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

 

[Project Mangler]

CG,

check out

http://www.cpearson.com/Excel/datedif.aspx

 

[Nadine]

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.

 

[David Biddulph]

For number of days, what would be the advantage of using DATEDIF instead of
just =TODAY()-A2 ?