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?