Trying to find average between two colums of dates

A

Andrew

I have two colums of dates and I need to find an average
numbers of days between the dates. An example would be a
column with dates work was done and a seperate column wiht
dates when work was due. I am looking to find the average
number of days work is turned in before it is due????
Make sense???? Now even I have a headache
 
V

Vasant Nanavati

Something like:

=SUM(B1:B100-A1:A100)/COUNT(A1:A100)

entered as an array formula with <Ctrl> <Shift> <Enter>.

You need to make sure that there is an entry in column B for each entry in
column A.
 

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

Need help with average/lookup formula 2
countifs Function not giving desired result with date criteria 2
Calculating an average of data between two dates 1
How can i find the max value within a time range ased on two cells 6
Trying to find additional ranges outside of min, max, and average 2
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
How do I average every 3rd cell in a column of a spreadsheet? 3

Top