Adding Text if a date is greater than a date in another cell

[ArcticAce]

I have the following formula in a cell:

=MIN(IF(Table1[@[6 Month Review Due]:[22 Month Final Review Due]]>TODAY(),Table1[@[6 Month Review Due]:[22 Month Final Review Due]]))

I would like to have "Recommendation Needed" to show in the cell if the date in 22 Month Final Review Due cell has passed. The cell right now is showing 1/0/1900.

I don't know to know how to do the formula to return the data.

Thank you in advance.

 

[becci.gott]

=IF(Table1[@[22 Month Final Review Due]] < TODAY(),"Recommendation Needed","")

 

[ArcticAce]

Can you give me more details, on how to get the text into the cell?

 

[Fluff]

I have edited becci.gott formula so it is now complete

 

[ArcticAce]

Maybe I can explain if differently. I have a range of cells with dates in them A2 thru A17, and I want to find the minimum date after today in the cell range. If all of the dates in the cell range are earlier than today, I want to add Recommendation Needed. Becci.Gott gave me an answer, but I don't see the min in the formula. I am fairly new to excel.

 

[ArcticAce]

Fluff, I think I am not explaining it correctly, because I still need the min date, in the cells, so let me try it again. Cells L-O are table columns labeled 6 month, 12 month, 18 month, and 22 month. k cell which is labeled Review due, to either find the next date after today, or return the "recommendation needed, if all dates have passed in the cell array. What you gave me works, but I need the date, if it hasn't passed, or the "Recommendation Needed", if it has passed. Thank you in advance.