I pasted dates from a pdf into my sheet. The dates go back to 2007, however
Excel recognizes all the dates as 2009. How do I remove the year from these
dates so I can add the correct year in its place and what is the best way to
add a year to a month day only cell?

Thanks