## Next upcoming date from list

*Article updated on July 19, 2017*

In a previous article Upcoming date I presented a solution that bolded dates within seven days from today using conditional formatting.

In this article the excel array formula searches for the the next upcoming date.

Column A contains date values and column B example data. See picture to the right.

Formula in cell E2: =INDEX($A$2:$A$8, MATCH(MIN($A$2:$A$8-$E$1), $A$2:$A$8-$E$1, 0)) + Ctrl + Shift + Enter. See picture below.

To customize the above formula to your excel sheet, you need to edit bolded ranges:

=INDEX(**$A$2:$A$8**, MATCH(MIN(**$A$2:$A$8**-$E$1), **$A$2:$A$8**-$E$1, 0))

Formula in cell E3: =INDEX($B$2:$B$8, MATCH(MIN($A$2:$A$8-$E$1), $A$2:$A$8-$E$1, 0)) + Ctrl + Shift + Enter

Download excel sample file for this tutorial.

next-upcoming-date

(Excel 97-2003 Workbook *.xls)

**Functions in this article:**

**MATCH(**lookup_value;lookup_array; [match_type]**)**

Returns the relative position of an item in an array that matches a specified value

**INDEX(**array,row_num,[column_num]**)**

Returns a value or reference of the cell at the intersection of a particular row and column, in a given range

**MIN(**number1,[number2]**)**

Returns the smallest number in a set of values. Ignores logical values and text

Lookup and return multiple values concatenated into one cell

This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]### 2 Responses to “Next upcoming date from list”

### Leave a Reply

**How to add a formula to your comment:**

<code>your formula</code>

Remember to convert less than and larger than signs to html character entities before you post your comment.

**How to add VBA code to your comment:**

[vb 1="vbnet" language=","]

VBA code

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org

Add picture link to comment.

**Contact Oscar**

You can contact me through this webpage

I use those two a lot together. Instead of a vlookup.

Christopher

But your formula only looks for the MIN date in the list of dates. I deleted the value in Today, and the result is the same