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.

Thanks in advance!

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

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