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
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.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I use something like this that may convert to what you want
So column D:D would be what you want to return and column A:A would be where you are searching...
Please Login or Register to view this content.
HTH
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
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.
Thank you so much (all of you that responded). Thanks Ben_hensel - perfect!
Originally Posted by ben_hensel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks