View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nadine nadine is offline
external usenet poster
 
Posts: 216
Default Is there a way to format a cell to show aging?

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.

"Carolina Girl" 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?