Thread: Formula needed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dhstein dhstein is offline
external usenet poster
 
Posts: 266
Default Formula needed

I have a sorted range of dates (in date format) from the past to the future
in column A. Cell B1 has =TODAY(). I need a formula that will give me the
row that divides the past from the future. So if today is 1/20/10 and cell
A75 has 1/15/10 and cell A76 has 2/3/10, the formula should return a value of
75. Thanks for any help on this.