Glad to hear that .. I've posted another response earlier - prematurely it
seems [g] - pl disregard that response

.. My problem was the date column also includes the time
not sure how to get rid of that besides doing it manually

If the above is the case in your source "dates" as-is,
we could use INT(..), viz try instead, array-entered in E1:
=MAX(IF(INT($A$1:$A$50000)=D1,$B$1:$B$50000))
Copy E1 down

(No need to manually work on the source "dates" in col A)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Cootha" wrote:
Max, now working. My problem was the date column also includes the time. not
sure how to get rid of that besides doing it manually, but it is working.
Thanks a heap!
Cootha