How to determine the date?

[Eric]

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

 

[T. Valko]

One way...

Try this array formula** :

=MIN(IF(A1:A4>TODAY(),A1:A4))

Format the cell as DATE. Note that if no dates meet the condition the
formula will return a 0 and a DATE formatted 0 will look like: 0-Jan-00. If
this might be a possibility and you don't want the 0 to appear in a DATE
format then use a custom format like this: d-mmm-yy;;0

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)