Array to find rows need to insert date criteria

[Excel 2003 - SPB]

How do I include a date limitation for a selected month into this array, the
date column is “C†the date is in J4 enters as 8/1/07
This returns the correct row numbers

=SMALL(IF(Data!$AE$2ata!$AE$3000>0,ROW(Data!$AE$2ata!$AE$3000)),ROW(1:1))


=SMALL(IF(Data!$AE$2ata!$AE$3000>0,ROW(Data!$AE$2ata!$AE$3000)*MONTH(Data!$C$2ata!$C$3000=MONTH($J$4))),ROW(1:1))

Thanks SPB

 

[Ragdyer]

I'm assuming that Column C is in the Data sheet, and the *array* formula and
J4 are *not*:

=SMALL(IF((Data!$AE$2:$AE$3000>0)*(TEXT(Data!$C$2:$C$3000,"mmm")=TEXT($J$4,"
mmm")),ROW(Data!$AE$2:$AE$3000)),ROWS($1:1))

--
Array formulas must be entered with CSE, <Ctrl> <Shift > <Enter>, instead of
the regular <Enter>, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.
You *must also* use CSE when revising the formula.

*After* the CSE entry, copy down as needed.

 

[Ragdyer]

BTW,
I didn't test for the year, so the formula will return *all* rows that
contain the month of August for *any* year.

To include the year in the reference, just revise the Text() functions to:

(TEXT(Data!$C$2:$C$30,"mmyy")=TEXT($J$4,"mmyy"))

 

[Ragdyer]

In case you didn't notice, I left off two 0's in the Column C range.

Should be:
(TEXT(Data!$C$2:$C$3000,"mmyy")=TEXT($J$4,"mmyy"))

 

[Excel 2003 - SPB]

Thanks
spent many hours, never thought of a "text string"

 

[Ragdyer]

You're welcome, and appreciate your feed-back.