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.