A1:A200
01/07/08
07/07/07
04/23/07
11/30/06


C1: I need average days between dates, considering leap years.

And is it possible to format C1 to equal.."2 month 3 days"
Thanks.

Here's my best guess...

Entered as an array** :

=AVERAGE(A1:A199-A2:A200)

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

>is it possible to format C1 to equal.."2 month 3 days"

Not really. How many days are in a month? 28, 29, 30, or 31?

The average of your posted sample is 134.333. How many months and days would
that be?


--
Biff
Microsoft Excel MVP


"Jman" <(E-Mail Removed)> wrote in message
news:991A17C6-15CC-4288-A5ED-(E-Mail Removed)...
> A1:A200
> 01/07/08
> 07/07/07
> 04/23/07
> 11/30/06
>
>
> C1: I need average days between dates, considering leap years.
>
> And is it possible to format C1 to equal.."2 month 3 days"
> Thanks.
>
>
>
>
>
>
>

What do you consider to be the average?

Is it the (Max - Min) / 2
Is it the sum of the differences divided by the count?
Is it something else?

I don't see how you get 2 months and 3 days with the data you provided.

Regards,
Fred.

"Jman" <(E-Mail Removed)> wrote in message
news:991A17C6-15CC-4288-A5ED-(E-Mail Removed)...
> A1:A200
> 01/07/08
> 07/07/07
> 04/23/07
> 11/30/06
>
>
> C1: I need average days between dates, considering leap years.
>
> And is it possible to format C1 to equal.."2 month 3 days"
> Thanks.
>
>
>
>
>
>
>

"The average of your posted sample is 134.333. How many months and days would
> that be?"

Is there a way to format it as to equal " 6m 15d" meaning 6months 15 days.

as in this formula.
=DATEDIF(A4,G2,"m")&"m "&DATEDIF(A4,G2,"md")&"d"


"T. Valko" wrote:

> Here's my best guess...
>
> Entered as an array** :
>
> =AVERAGE(A1:A199-A2:A200)
>
> ** array formulas need to be entered using the key combination of
> CTRL,SHIFT,ENTER (not just ENTER)
>
> >is it possible to format C1 to equal.."2 month 3 days"
>
> Not really. How many days are in a month? 28, 29, 30, or 31?
>
> The average of your posted sample is 134.333. How many months and days would
> that be?
>
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "Jman" <(E-Mail Removed)> wrote in message
> news:991A17C6-15CC-4288-A5ED-(E-Mail Removed)...
> > A1:A200
> > 01/07/08
> > 07/07/07
> > 04/23/07
> > 11/30/06
> >
> >
> > C1: I need average days between dates, considering leap years.
> >
> > And is it possible to format C1 to equal.."2 month 3 days"
> > Thanks.
> >
> >
> >
> >
> >
> >
> >
>
>
>

"Fred Smith" wrote:

> What do you consider to be the average?
>
> Is it the (Max - Min) / 2
> Is it the sum of the differences divided by the count?
> Is it something else?
>
> I don't see how you get 2 months and 3 days with the data you provided.
>
> Regards,
> Fred.
>
> "Jman" <(E-Mail Removed)> wrote in message
> news:991A17C6-15CC-4288-A5ED-(E-Mail Removed)...
> > A1:A200
> > 01/07/08
> > 07/07/07
> > 04/23/07
> > 11/30/06
> >
> >
> > C1: I need average days between dates, considering leap years.
> >
> > And is it possible to format C1 to equal.."2 month 3 days"
> > Thanks.
> >
> >
> >
> >My bad, i didnt explain myself enough, the "2 "months and "3" day is just an example how i want the cell to be formated.
=DATEDIF(A4,G2,"m")&"m "&DATEDIF(A4,G2,"md")&"d"

I used this formula and it gave me.. cell format example. (""m ""d)

> >
> >
> >
>
>

>> "The average of your posted sample is 134.333.
> Is there a way to format it as to equal " 6m 15d" meaning 6months 15 days

Can you explain how 134.333 equals 6m 15d ?

?????????

--
Biff
Microsoft Excel MVP


"Jman" <(E-Mail Removed)> wrote in message
news:7ADAFF8C-6E6F-482A-A6A7-(E-Mail Removed)...
> "The average of your posted sample is 134.333. How many months and days
> would
>> that be?"
>
> Is there a way to format it as to equal " 6m 15d" meaning 6months 15
> days.
>
> as in this formula.
> =DATEDIF(A4,G2,"m")&"m "&DATEDIF(A4,G2,"md")&"d"
>
>
> "T. Valko" wrote:
>
>> Here's my best guess...
>>
>> Entered as an array** :
>>
>> =AVERAGE(A1:A199-A2:A200)
>>
>> ** array formulas need to be entered using the key combination of
>> CTRL,SHIFT,ENTER (not just ENTER)
>>
>> >is it possible to format C1 to equal.."2 month 3 days"
>>
>> Not really. How many days are in a month? 28, 29, 30, or 31?
>>
>> The average of your posted sample is 134.333. How many months and days
>> would
>> that be?
>>
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Jman" <(E-Mail Removed)> wrote in message
>> news:991A17C6-15CC-4288-A5ED-(E-Mail Removed)...
>> > A1:A200
>> > 01/07/08
>> > 07/07/07
>> > 04/23/07
>> > 11/30/06
>> >
>> >
>> > C1: I need average days between dates, considering leap years.
>> >
>> > And is it possible to format C1 to equal.."2 month 3 days"
>> > Thanks.
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>>
>>
>>

LOL

Iam dumb founded. I just realized there no way to do.
I know 6m and 15 was just a number i threw out. . Like you said there are
different days in a month so there is no way to do it.
"T. Valko" wrote:

> >> "The average of your posted sample is 134.333.
> > Is there a way to format it as to equal " 6m 15d" meaning 6months 15 days
>
> Can you explain how 134.333 equals 6m 15d ?
>
> ?????????
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "Jman" <(E-Mail Removed)> wrote in message
> news:7ADAFF8C-6E6F-482A-A6A7-(E-Mail Removed)...
> > "The average of your posted sample is 134.333. How many months and days
> > would
> >> that be?"
> >
> > Is there a way to format it as to equal " 6m 15d" meaning 6months 15
> > days.
> >
> > as in this formula.
> > =DATEDIF(A4,G2,"m")&"m "&DATEDIF(A4,G2,"md")&"d"
> >
> >
> > "T. Valko" wrote:
> >
> >> Here's my best guess...
> >>
> >> Entered as an array** :
> >>
> >> =AVERAGE(A1:A199-A2:A200)
> >>
> >> ** array formulas need to be entered using the key combination of
> >> CTRL,SHIFT,ENTER (not just ENTER)
> >>
> >> >is it possible to format C1 to equal.."2 month 3 days"
> >>
> >> Not really. How many days are in a month? 28, 29, 30, or 31?
> >>
> >> The average of your posted sample is 134.333. How many months and days
> >> would
> >> that be?
> >>
> >>
> >> --
> >> Biff
> >> Microsoft Excel MVP
> >>
> >>
> >> "Jman" <(E-Mail Removed)> wrote in message
> >> news:991A17C6-15CC-4288-A5ED-(E-Mail Removed)...
> >> > A1:A200
> >> > 01/07/08
> >> > 07/07/07
> >> > 04/23/07
> >> > 11/30/06
> >> >
> >> >
> >> > C1: I need average days between dates, considering leap years.
> >> >
> >> > And is it possible to format C1 to equal.."2 month 3 days"
> >> > Thanks.
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >>
>
>
>