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

Average between dates considering leap years. 6
Min if Function? 4
Subtracting time...again 2
Calculating the difference between two dates if two criteria are m 3
nested datevalue if and statements 5
Difference between two date/time values 5
Sum value between two dates and copy to new cell 6
Sum amount of days in another coloumn 8

Top