I have a list of dates on column A. Each day I need to automatically put the date of today or the next closest date on cell B1.
20/8/2018 6/9/2018 25/9/2018 28/9/2018 11/10/2018 30/10/2018 31/10/2018 10/11/2018 15/11/2018 15/12/2018
I already tried using MATCH but it returns and index value. I could use INDEX to get the date corresponding to that index value.
Is there a simpler/ straight forward way to achieve the same result?