pevious date searching

[mort1703]

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

 

[RonB1111]

If your list of dates are all prior to "today", then you could use a simple: =MAX(E7:G7)

However, if your list of dates includes dates both prior and after "today", then try this CSE formula (confirm with Ctrl+Shift+Enter, do not just hit the Enter key - if confirmed correctly, then curly brackets { } will surround the formula in the formula bar):

=INDEX(E1:G1,0,MATCH(MIN(ABS(E1:G1-TODAY())),ABS(E1:G1-TODAY()),0))

If it happens that a date before and after today are both the closest with the same number of days from today, then the formula will bring whichever date is listed 1st.