Eg., For the month of JAN - Avg number of days
= 10+2 = 12/2 = 6 days.

Think you missed one for Jan.

Are these possible:

What if a date range spans more than a single month?

1/29/2008 - 2/5/2008

What if a date range spans multiple months:

1/29/2008 - 6/21/2008

--
Biff
Microsoft Excel MVP


"muddan madhu" wrote in message
...
Hi All,

In a spread sheet i have dates in col A and Col B (start date and end
date).
Col A Col B Dates Count Status
01-jan-08 10-jan-08 10 days Completed
10-feb-08 15-feb-08 5 days Completed
07-jan-08 09-jan-08 2 days Pending
10-jan-08 12-jan-08 2 days
Completed
.
.

Like this i have more than 200 rows. I need Avg number of "days" for
the "completed" rows based on the month.
Eg., For the month of JAN - Avg number of days = 10+2 = 12/2 = 6 days.

Dates count I have inserted for example, actually in original file
there is no column called Dates count.

Is this possible to get desired answer from excel formulas itself ?

Thanks in advance.