Average days between dates



Greetings all,

I am working with two columns (ranges) of dates, although there are many
blank rows interspersed in both ranges. I simply need to calculate the
overall average days elapsed between the two columns. In other words, I'm
looking for a single result here; Col. B (End date) - Col. A (Start date) for
as many rows of dates that exist.

COL A (Start) COL B (End)
01/05/09 02/20/09
03/12/09 03/09/09

01/15/09 01/30/09
02/19/09 02/22/09

The array formula I'm using (below) works, but is factoring in the blank
cells and is giving me a lower inaccurate result.


Any help at all would be appreciated.

Jarek Kujawa

presuming blanks are always in neighbouring A and B


CTRL+SHIFT+ENTER it as it is an array formula

Sean Timmons


should get it. If it still account for the blank cells, they are not blank.
If the cell is, perhaps, " ", then you can either delete these or change the
sumproduct to <> " "


Here's another way...


....confirmed with CONTROL+SHIFT+ENTER. Note that this formula allows
formula blanks ("").

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