Enter date based on another date

[MPFraser7]

The title doesn't say much so let me explain further.

The value in A2 is manual input and it could be any date in the calendar, from 1999 to 2017. In column B, I need to enter a formula that returns which ever comes first, November 6th or the day and month of A2 + 1 year. Refer to table for an example of desired results

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date1[/TD]
[TD]Date2[/TD]
[/TR]
[TR]
[TD]09/07/2014[/TD]
[TD]06/11/2014[/TD]
[/TR]
[TR]
[TD]07/11/2014[/TD]
[TD]09/07/2015[/TD]
[/TR]
[TR]
[TD]10/07/2015[/TD]
[TD]06/11/2015[/TD]
[/TR]
[TR]
[TD]07/11/2015[/TD]
[TD]09/07/2016[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

I think this version solves the hire date after November 7th issue:

=IF(TEXT(A2,"mmdd")+0<=1106,DATE(YEAR(A2),11,6),IF(TEXT(A2,"mmdd")+0=1107,DATE(YEAR(A2)+1,MONTH($A$2),DAY($A$2)), DATE(YEAR(A2)+1,11,6)))