Average days between multiple dates

J

Jman

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.
 
V

vezerid

=AVERAGE(A2:A200-A1:A199)

Commit with Shift+Ctrl+Enter (array formula)

HTH
Kostis Vezerides
 
J

Jman

i keep getting 198. 81 although i change dates.

vezerid said:
=AVERAGE(A2:A200-A1:A199)

Commit with Shift+Ctrl+Enter (array formula)

HTH
Kostis Vezerides
Click to expand...
 
V

vezerid

Yes you are: now that I thought it over again and tested it, obviously
the average will be equal to the last date minus the first date
divided by the number of dates. Hence if you change any intermediate
dates the average will stay the same. It will only change if you
change the 1st or last date.

Does this help?
 
J

Jman

oh. i see.
thanks


vezerid said:
Yes you are: now that I thought it over again and tested it, obviously
the average will be equal to the last date minus the first date
divided by the number of dates. Hence if you change any intermediate
dates the average will stay the same. It will only change if you
change the 1st or last date.

Does this help?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Average between dates considering leap years. 6
Subtracting time...again 2
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
IF ARRAY with multiple conditions. 1
Min if Function? 4
Schedule Events 2
Reverse Index Match 2

Top