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.

	A	B	C	D	E	F	G	H	I	J	K
1	Next Review Date	JAN Review	FEB Review	MAR Review	APR Review	MAY Review	JUN Review	JUL Review	AUG Review	SEP Review	Final Review
2	3/31/2018	1/31/2018	2/28/2018	3/31/2018	4/30/2018	5/31/2018	6/30/2018	7/31/2018	8/31/2018	9/30/2018	10/31/2018
3	4/30/2018				4/30/2018	5/31/2018		7/31/2018	8/31/2018	9/31/2018	10/31/2018

<tbody>
</tbody>

 

[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?