Trying to find average between two colums of dates

  • Thread starter Thread starter Andrew
  • Start date Start date
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
 
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.
 
Back
Top