Thank you so much for the quck reply

in case anybody wants to know exactly what i used... here it is (for
row 2):


Code:
--------------------
=IF(ISNUMBER(SEARCH("??/??/????", A2)),DATEVALUE(MID(A2,SEARCH("/??/",A2,1)-2,10)), "")
--------------------


i first needed to search to make sure that there was a date on that
line in the first place, i also needed to use wildcards because there
were slashes on other lines, and because i used wildcards i needed to
change the find to search. last i used datevalue to make it a number
value so i could find the minimum, and just changed the format to date
so it would still look like a date.


now to find a minimum date:
if it were done by hand i coud just say

Code:
--------------------
=MIN(J188:J199)
--------------------

but i would like it to start on any row that has a value in the k
column and go up to any row that has a value of "client aged A/R" in
the A column

the start column would be fine, just make it an if statement that only
works for rows that have values in the K column, but how would i make
it automatically stop

here is what i have so far:


Code:
--------------------
=IF(L200="","",MIN(J188:J200))
--------------------


i just need to figure out what i can plug in instead of J188


--
ryan00davis
------------------------------------------------------------------------
ryan00davis's Profile: http://www.excelforum.com/member.php...o&userid=37344
View this thread: http://www.excelforum.com/showthread...hreadid=570458