I have a list of dates ranging from October 5, 2009 to August 12, 2013 starting in column F3. I need to create a due date starting in column M3. The month and day need to be the same as F3 the year needs to be the current year and change automatically when a new year rolls over. For example if cell F3 is Oct 5, 2009 cell M3 needs to be Oct 5, 2013 and change to Oct 5, 2014 once the new year rolls over.
Bookmarks