Semi Annual Dates

I am trying to have excel return a Semi Annual date (my two dates are 1 April and 1 November) from a date in cell A1 but my current formula will not switch to the next year once I get to December. The year of my date only changes to my next Semi Annual date and year once I am in January of the next year.

Example: Cell A1 Date: October 1, 2016 returns the correct Semi Annual date of November 1, 2016 based on the formula below:

=IF(MONTH(A1)>4,DATE(YEAR(A1),11,1),DATE(YEAR(A1),4,1))

Once the date is December 1, 2016 in cell A1 I would like it to return 1 April, 2017.

Please let me know if you can help the formula works great except in December.

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

http://www.excelforum.com/excel-form...next-year.html