| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to format a cell to show aging?
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a way to format a cell to show aging?
=TODAY()-A2
-- David Biddulph "Carolina Girl" <Carolina wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a way to format a cell to show aging?
|
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a way to format a cell to show aging?
For number of days, what would be the advantage of using DATEDIF instead of
just =TODAY()-A2 ? -- David Biddulph "Project Mangler" wrote in message ... CG, check out http://www.cpearson.com/Excel/datedif.aspx "Carolina Girl" <Carolina wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format a cell value to show kg? | Excel Discussion (Misc queries) | |||
| Format cell to show '-' | Excel Discussion (Misc queries) | |||
| Aging - show net due in oldest age category | Excel Discussion (Misc queries) | |||
| format cell to show leading zeros and make cell a three digit fiel | Excel Worksheet Functions | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
![Carolina Girl[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
