Worked Like a charm ! Thank you so very much guys -

T. Valko wrote:
Try this array formula** :

=INDEX(A2:A5,MATCH(TRUE,D2:D5<=B1,0))

I'm assuming there are no empty cells in column D.

Format the result as DATE

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Biff

Good morning,

[quoted text clipped - 18 lines]

Thank you

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200706/1