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

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

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

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

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