# Find closest date to today in a row of dates

1. ## Find closest date to today in a row of dates

Hi all,

I have a bunch of key dates (business reviews) that span a year or so that are held in a row (AC:CN). In a summary page I would like to return the nearest date to todays date. This way the team will always know what date the next review is. (I cannot use a calendar for this!!)

I hope you can help!

Thanks
Scott

2. ## Re: Find closest date to today in a row of dates

The first comming (next) day or (earlier) day?

I think you need the next day.

It would be helpfull (for me) if you add an small exel file, without confidential information.

Please add also the desired (expected) result.

3. ## Re: Find closest date to today in a row of dates

I use something like this that may convert to what you want

``Please Login or Register  to view this content.``
So column D:D would be what you want to return and column A:A would be where you are searching...

HTH

4. ## Re: Find closest date to today in a row of dates

Assuming that the dates arranged in increasing order;
Assuming that the dates are in one row, AC1:CN1 for example:

=INDEX(AC1:CN1, MATCH( TODAY(), AC1:CN1, 1) +1)

Note that if there is a review "today" it will display the review after today.

5. ## Re: Find closest date to today in a row of dates

Thank you so much (all of you that responded). Thanks Ben_hensel - perfect!

Originally Posted by ben_hensel
Assuming that the dates arranged in increasing order;
Assuming that the dates are in one row, AC1:CN1 for example:

=INDEX(AC1:CN1, MATCH( TODAY(), AC1:CN1, 1) +1)

Note that if there is a review "today" it will display the review after today.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1