Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average formula for dates range - Excell 2007
I am currently using a formula to calculate aging between dates. How can I
take that calculated column of information and find an average for aging? Thank you in advance. Radrays |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average formula for dates range - Excell 2007
Hi,
The question is clear but if you have a column of ages and you want the average age then =average(a1:a100) change range to suit Mike "Radrays" wrote: I am currently using a formula to calculate aging between dates. How can I take that calculated column of information and find an average for aging? Thank you in advance. Radrays |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average formula for dates range - Excell 2007
Here are dates in cols A & B and date aging in column C:
4/7/2009 3/24/2009 14 4/7/2009 4/6/2009 1 4/7/2009 3/19/2009 19 4/7/2009 3/25/2009 13 4/7/2009 4/3/2009 4 4/7/2009 4/2/2009 5 4/7/2009 3/27/2009 11 4/7/2009 3/31/2009 7 4/7/2009 3/24/2009 14 4/7/2009 4/6/2009 1 Then in another cell: =AVERAGE(C1:C10) will display 9 -- Gary''s Student - gsnu200843 "Radrays" wrote: I am currently using a formula to calculate aging between dates. How can I take that calculated column of information and find an average for aging? Thank you in advance. Radrays |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average formula for dates range - Excell 2007
Below is the formula for the aging
=IF(DATEDIF(C3,D3,"y")=0,"",DATEDIF(C3,D3,"y")&" year(s),")&IF(DATEDIF(C3,D3,"ym")=0,"",DATEDIF(C3, D3,"ym")&" month(s),")&DATEDIF(C3,D3,"md")&" day(s)" How can I convert in a seperate column to days only - then I could use that column for the average...correct? Thank you for your help, Radrays "Mike H" wrote: Hi, The question is clear but if you have a column of ages and you want the average age then =average(a1:a100) change range to suit Mike "Radrays" wrote: I am currently using a formula to calculate aging between dates. How can I take that calculated column of information and find an average for aging? Thank you in advance. Radrays |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average formula for dates range - Excell 2007
With your dates in C3:D20 use this array formula (commit with CTRL+SHIFT+ENTER)
for the average: =SUM(C3:C20-D3:D20)/SUM(--(C3:C20-D3:D20<0)) Radrays wrote: Below is the formula for the aging =IF(DATEDIF(C3,D3,"y")=0,"",DATEDIF(C3,D3,"y")&" year(s),")&IF(DATEDIF(C3,D3,"ym")=0,"",DATEDIF(C3, D3,"ym")&" month(s),")&DATEDIF(C3,D3,"md")&" day(s)" How can I convert in a seperate column to days only - then I could use that column for the average...correct? Thank you for your help, Radrays "Mike H" wrote: Hi, The question is clear but if you have a column of ages and you want the average age then =average(a1:a100) change range to suit Mike "Radrays" wrote: I am currently using a formula to calculate aging between dates. How can I take that calculated column of information and find an average for aging? Thank you in advance. Radrays |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I Count number of records beteen two dates- Excell 2007 | Excel Worksheet Functions | |||
Help with Formula in excell 2007 | New Users to Excel | |||
formula in excell 2007 | Excel Worksheet Functions | |||
Need to average a range AND calc a formula at once... | Excel Worksheet Functions | |||
How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel |