# Show upcoming date - Excel formula

1. ## Show upcoming date - Excel formula

Hi!

I have a range of dates which I want to compare to todays date by using my formula.
The idea is that the formula will show the upcoming date based on that range. For example, if the range look like this;

2015-01-20
2015-02-20
2015-03-20
2015-04-20
2015-05-20
2015-06-20
2015-07-20
2015-08-20
2015-09-20
2015-10-20
2015-11-20

The formula should give me 2015-10-20, if today was 2015-10-21 it should give me 2015-11-20.
I tried to use this formula but it only gave me 1900-01-01. It must be something simple I am missing.

Formula:
`Please Login or Register  to view this content.`

2. ## Re: Show upcoming date - Excel formula

Sounds like the dates in A2:A12 are not really dates.

What does this return
=ISNUMBER(A2) and filled down

3. ## Re: Show upcoming date - Excel formula

D1 = today()

E1 = INDEX(\$A\$1:\$A\$11,match(\$D\$1,\$A\$1:\$A\$11,1)+1,1)

4. ## Re: Show upcoming date - Excel formula

Thank you both for your quick reply! I managed to solve it eventually
My first strategy was actually to tackle this using INDEX and MATCH but I didnt think of including +1.

Oeldere - Could you possible just explain what the last part of the parenthese do? This part +1,1)...

5. ## Re: Show upcoming date - Excel formula

This part +1,1)...

+1 => take the next value instead of the found value.

,1 take the result from column 1 in the index (in this case A).

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