All three columns. Two of the columns have the date format but the renewal column contains just the year.

I apologize for the extra work. I realize being new to asking for help like this is no reason not to be clear about what I wanted from the beginning. I will make sure it is more explained in the future.