Need help writing a formula

[Beans42]

I am looking for a formula that will take a number in a given cell (A1), run it against a range of numbers (b1:b30) to see when it is greater than one of them, and then return the date in the cell adjacent to the range (c1:c30)

[#2]

@Beans42 

is this what you want?