View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to determine the date?

Does anyone have any suggestions on how to determine the date?
There is a list of dates under column A
11-Aug-07
1-Sep-07
15-Oct-07
20-Dec-07

I would like to determine which date is the closest to today(), but larger
than today(). 1-Sep-07 should be returned in cell B1
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric