Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
-Julie -Julie is offline
external usenet poster
 
Posts: 2
Default Formula Help

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