Keeping a date as current year, even though formula determines previous year

It may be best to show this issue with an attachment. I need the cells in column E to always be current year even though they are based on a formula from column B which contains various years. Is this possible? I'm looking to conditionally format column F as black fill if the date has passed. Was not a problem in column C where there is a one time occurrence. Is there a better way to do this?

You can use this formula in E3:

=DATE(YEAR(TODAY()),MONTH(B3+180),DAY(B3+180))

then copy it down.

Hope this helps.

Pete

Thank you for your help Pete. Worked like a charm. Thanks given!