Get the nearest future date from 3 columns

[QuietRiot]

What would be the best way of going about getting the nearest future date from 3 dates using todays date?

A---------- b----------c-----------answer
3/29/2016 3/29/2017 3/30/2018 3/30/2018
2/15/2019 2/15/2020 2/15/2021 2/15/2019
6/25/2016 5/25/2017 5/25/2018 5/25/2018

 

[MARZIOTULLIO]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

a​

[/TD]
[TD]

b​

[/TD]
[TD]

c​

[/TD]
[TD]

d​

[/TD]
[TD]

e​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]

3/29/2016​

[/TD]
[TD]

3/29/2017​

[/TD]
[TD]

3/30/2018​

[/TD]
[TD][/TD]
[TD]

3/30/2018​

[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

2/15/2019​

[/TD]
[TD]

2/15/2020​

[/TD]
[TD]

2/15/2021​

[/TD]
[TD][/TD]
[TD]

2/15/2019​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

6/25/2016​

[/TD]
[TD]

5/25/2017​

[/TD]
[TD]

5/25/2018​

[/TD]
[TD][/TD]
[TD]

5/25/2018​

[/TD]
[/TR]
</tbody>[/TABLE]

e1=INDEX(A1:C1,MATCH(MIN(ABS(TODAY()-A1:C1)),ABS(TODAY()-A1:C1),0)) control+shift+enter copy down

format column E as date

 

[QuietRiot]

e1=INDEX(A1:C1,MATCH(MIN(ABS(TODAY()-A1:C1)),ABS(TODAY()-A1:C1),0)) control+shift+enter copy down

format column E as date

very close, but I need the future date and not any past. Example where it messed up:

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

a​

[/TD]
[TD]

b​

[/TD]
[TD]

c​

[/TD]
[TD]

d​

[/TD]
[TD]

e​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]

12/3/2016​

[/TD]
[TD]

11/9/2017​

[/TD]
[TD]

12/3/2018​

[/TD]
[TD][/TD]
[TD]

11/9/2017​

[/TD]
[/TR]
</tbody>[/TABLE]