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

Date1	Date2
09/07/2014	06/11/2014
07/11/2014	09/07/2015
10/07/2015	06/11/2015
07/11/2015	09/07/2016

<tbody>
</tbody>

 

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