I need help creating a formula, please. If column a contains today() and
column b contains dates and column c contains a number, I want the formula to
look at today's date and find the date closest but not higher than today and
return the corresponding number. In this case, I want an answer of "2"
returned.
A B C
1 06/11/2009 05/15/2009 1
2 05/31/2009 2
3 06/15/2009 3