Folks,

I'm struggling to resolve this Execl formula.

I've got a workbook with 2 sheets: Summary and Source Data. The workbook is
used a template so that data exported from another system can be copied and
pasted into the Source Data sheet and the Summary sheet will
programmatically parse the data to provide the results that I am looking
for.

The Source Data sheet has a number of named ranges. My problem relates to
the range named DATE (D2:D10000). This range contains dates formatted as
"=DATE(2008,1,1)" for Jan 1, 2008 as an example. In virtually every case,
there will be blank cells in the range since the data is less than 10K
rows).

The Summary sheet uses formulas to summarize the data contained in the
Source Data sheet by month, category, and so forth. In cell $B$16, a numeral
(1-12) is entered to specifiy the month for which the records in Source Data
are to be summarized. I then use two formulas that examine the dates in the
DATE range and provide the MIN and MAX date so the date range can be
displayed.

Here are the array formulas I am using to get these MIN and MAX dates:
{=MIN(IF(MONTH(Date)=$B16,Date,"N/A"))}
{=MAX(IF(MONTH(Date)=$B16,Date,"N/A"))}

Here is my problem (assuming that the data in Source Data contains
transactions from 01/01/08 through 03/06/08):

When 1 is entered in $B$16:
MIN returns 0-Jan-00 (INCORRECT - should be 1-Jan-08)
MAX returns 31-Jan-08 (correct)

When 2 is entered in $B$16:
MIN returns 1-Feb-08 (correct)
MAX returns 29-Feb-08  (correct)

When 3 is entered in $B$16:
MIN returns 1-Mar-08  (correct)
MAX returns 6-Mar-08 (correct)

When 4 is entered in $B$16:
MIN returns 0-Jan-00 (INCORRECT - should be N/A)
MAX returns 0-Jan-00 (INCORRECT - should be N/A)

I think that the blank cells in the DATE range are screwing me up but I am
at a loss on how to check for them and also how to report N/A when the month
in $B$16 represents no transactions in the Source Data sheet.

Appreciate any advice.

Thanks,
David