When you say wildcard, I'm assuming B1 is start of date range (K10 or
whatever),
And B2 is end of date range (K11 or whatever).

=MIN(DATEVALUE(SUBSTITUTE(INDIRECT(B1&":"&B2),".", "/")))

Although you didn't mention it, since it's your formula, you know that it's
an *array* formula, but for the sake of other readers:

Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the
regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Jeff" wrote in message
...

I need to run a formula that would do this on an active cell:
=MIN(DATEVALUE(SUBSTITUTE('408134.xls'!K10:K11,"." ,"/")))

But instead of delimiting the range from K10:K11, I would like the formula
to evaluate the column K with a range defined within two wildcards *,
located
in column B.
The upper range would be *
The lower range would also be *

This would be continuous, therefore the formula needs to go the next range
delimited by two wildcards *
Regards,