Thread
:
Is there a way to format a cell to show aging?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Lars-Åke Aspelin[_4_]
external usenet poster
Posts: 83
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
Reply With Quote
Lars-Åke Aspelin[_4_]
View Public Profile
Find all posts by Lars-Åke Aspelin[_4_]