IF function

[ShouldBEasy]

HI,

Can someone assist in making a cell with the following:

I have:
-4 cells with different consecutive increasing dates (ie. 1 June, 2014 - 1 July, 2014, etc....) For practical reasons, let's call these cells A,B,C,D
-Today's date

I need:
The created cell to give me back the number of days between TODAY and the first available of the dates (A). If the date (A) has passed, then the countdown goes to the next date (B) and so on.

So in other words:
Cell gives displays the value of: Today-(A) if positive
If not positive, Cell gives the value of Today - (B) if positive
If not positive, Cell gives the value of Today - (C), etc.........

[Down Under]

Try this:

=MIN(IF((A1:A4-TODAY()>0),A1:A4-TODAY()," "))

[ATLGator]

Also, make sure to use SHIFT+CTRL+ENTER after you've entered the formula into the cell

[ShouldBEasy]

Amazing. Thank you Down Under and ATLGator. It's working.