Do you mean by non contiguous that there are empty cells in among your
dates in column A, or that some dates are missing within a contiguous
range?

Pete

On Oct 6, 8:18*am, u473 wrote:
*Sorted, non contiguous dates are in column "A" formatted as MM/DD/
YY.
Target date is retrieved from an Inputbox. Format MM/DD/YYYY
*However. *Because the stored value is not the same as the displayed
Formatted date, I have tried. to use *DateValue inside a Vlookup or
Find What, *and test for Less or Equal *inside a Loop, since my range
of dates may not be contiguous.
So far I have not found the solution.
Your help will be appreciated.
J.P.