Date and If function

Hello,

Thank you for your time!

I want excel to determine the date on multiple conditions.
If the given date in A1 is 29-Nov-1980 and one of the conditions is 30-Jun-2016 then the date should result to 29-Nov-2014. Please refer to the table below for more conditions.

Date of joining As of this year Condition 1

27-Jun-05 27-Jun-15 30-Sep-15
02-Jul-05 02-Jul-15 30-Sep-15

10-Sep-05 10-Sep-13 30-Sep-15
01-Dec-05 01-Dec-13 30-Sep-15

15-Jul-06 15-Jul-14 30-Sep-15
07-Aug-06 07-Aug-14 30-Sep-15

The table above is the actual solution that I am looking for. I have huge data and have to process every month. The second condition deals with Odd and Even years.

Please help me in this if possible.

Many thanks in advance!

best regards,

Arun