|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 7th, 2010, 09:18 PM
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
May 7th, 2010, 09:25 PM
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
May 7th, 2010, 09:27 PM
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
May 7th, 2010, 09:30 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a way to format a cell to show aging?
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?
|
|
#5
May 7th, 2010, 09:34 PM
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
May 8th, 2010, 09:19 AM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
