A1:A23 are dates from 15/12/09 to 06/01/10. Column B will have random numbers, up to 5 decimals long next to these dates.
What I need to do is to input a whole number in cell G2 (taget cell) and from this it will give me the most recent date at which the data is equal to or less than the target cell (into cell H2).
Can this be done via a simple formula?
What I need to do is to input a whole number in cell G2 (taget cell) and from this it will give me the most recent date at which the data is equal to or less than the target cell (into cell H2).
Can this be done via a simple formula?