convert the birth date to the current /next year with specific conditions

Greetings for the day.

I'm looking for a formula that can convert the birthday date on the "E column" to the current/next year carrying the same day and month, and that will be dependent on the month given at the birthday date on the "E column".

The first logic is if the birthday month on the "E column" has already passed, then the return birthday date will be converted to the next year on the "D column.

The second logic is if the birthday month on the "E column" is matching the current month or coming next then the return birthday date will be converted to this year on the "D column.

And if the cell is empty in the "E column" then it should return an empty value in the "D column.

I hope to find the correct formula that can cover the full condition mentioned above.

I have attached a screenshot as well as the worksheet for reference.

2323322322.jpg
Book22656.xlsx

@AliGW this is amazing and it worked perfectly.

But one more condition is missing! and that is when there is no date mentioned in the "E column" the formula should return an empty result.

@AliGW has already included that at the very beginning of the function. It work as per your request.

Another way:

=IF(E5="","",EDATE(E5,FLOOR(DATEDIF(E5,TODAY()-1,"m"),12)+12))

@AliGW apologize for missing that area as well, yeh it's fully recovered and working perfectly.

thank you again and have a wonderful day ahead.

this is a fantastic platform and outstanding members.

thank you always.