View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lars-Åke Aspelin[_4_] Lars-Åke Aspelin[_4_] is offline
external usenet poster
 
Posts: 83
Default Is there a way to format a cell to show aging?

On Fri, 7 May 2010 13:18:01 -0700, Carolina Girl <Carolina
wrote:

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