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