View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike K Mike K is offline
external usenet poster
 
Posts: 104
Default Very simple match function help

Oh Wise Ones,
I'm kinda embarrassed by this one but I can't get it
to work. If I have =NOW() in I3 and in G9:G20 I have these dates:
2/03/07
3/03/07
4/03/07
5/03/07
.......
1/03/08

Shouldn't (in J3) =MATCH(I3,G9:G20,1) return 4/01/07? It returns 2/02/2008 I
need the get the closest to but more than todays date from that column.
Please help

Thanks,
Mike