Formula for closest date after today in a range with a few blank cells

[ArcticAce]

I need a formula that will give me the minimum date after today, and it needs to ignore blank cells.

Employee reviews are conducted after the employee is employed.

In ROW 3, lets day the employee starts today, and will be away in training for the month of June.

How do I skip the blanks spaces before May, and skip June to always get the minimum date.

I only used two rows, but this is for hundreds of employees.

Thanks in advance for your assistance.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Next Review Date[/TD]
[TD]JAN Review[/TD]
[TD]FEB Review[/TD]
[TD]MAR Review[/TD]
[TD]APR Review[/TD]
[TD]MAY Review[/TD]
[TD]JUN Review[/TD]
[TD]JUL Review[/TD]
[TD]AUG Review[/TD]
[TD]SEP Review[/TD]
[TD]Final Review[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3/31/2018[/TD]
[TD]1/31/2018[/TD]
[TD]2/28/2018[/TD]
[TD]3/31/2018[/TD]
[TD]4/30/2018[/TD]
[TD]5/31/2018[/TD]
[TD]6/30/2018[/TD]
[TD]7/31/2018[/TD]
[TD]8/31/2018[/TD]
[TD]9/30/2018[/TD]
[TD]10/31/2018[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4/30/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4/30/2018[/TD]
[TD]5/31/2018[/TD]
[TD][/TD]
[TD]7/31/2018[/TD]
[TD]8/31/2018[/TD]
[TD]9/31/2018[/TD]
[TD]10/31/2018[/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Hi,

Wouldn't we need to know the "Hire Date/Month" and the "Training Date/Month" in order to know which months to skip?
Where would that information be in the Table?

 

[ArcticAce]

Jtakw, thank you for your reply. I got it figured out and it's working correctly. The hire date isn't a factor, because it all based on the initial discussion, which I did forgot to include in the example.

 

[Aladin Akyurek]

Jtakw, thank you for your reply. I got it figured out and it's working correctly. The hire date isn't a factor, because it all based on the initial discussion, which I did forgot to include in the example.

Others might be interested in the solution you implemented. So, care to share it?