find the date from this list that is closest to today().

I assume that closest means either before or after (if not an exact match).

Normally entered:

=INDEX(B1:BK1,MATCH(TRUE,INDEX(ABS(B1:BK1-TODAY())=MIN(INDEX(ABS(B1:BK1-TODAY()),1,)),1,),0))

Format as DATE

--
Biff
Microsoft Excel MVP


"jem264" wrote in message
...
I have a list of dates in row 1, from B1:BK1. Most of them are Sundays, but
a
few are in the middle of the week. I need a formula that I can enter into
another sheet to find the date from this list that is closest to today().
I
found an array formula that will work, I hope to be able to do this
without
the array, I do not want to add any more data to the sheets, if possible.
Thanks in advance