Hi
I have a row of 52 dates, is their a way of searching through the range of dates to give me the closest date to today for example
01/04/2015 01/02/2015 01/03/2015
for arguments sake the columns can be E1:G1 for simplicity.
Today Date is 01/06/2015 - I would like it search the above dates and return 01/04/2015.
The field searching is H1 for the example
Any help would be appreciated
I have a row of 52 dates, is their a way of searching through the range of dates to give me the closest date to today for example
01/04/2015 01/02/2015 01/03/2015
for arguments sake the columns can be E1:G1 for simplicity.
Today Date is 01/06/2015 - I would like it search the above dates and return 01/04/2015.
The field searching is H1 for the example
Any help would be appreciated