title: Convert calendar date in Excel to same weekday in future years
body: <p>I have a spreadsheet I have created from Outlook calendar export for 2014.  I need to rollover the StartDate dates in my spreadsheet (B3) to the same day of the week in 2015 (e.g., Monday appointment in 2014 needs to be on Monday in 2015).  I've tried:  =DATE(YEAR(TODAY()),MONTH(B3),DAY(B3))  This formula only gives me the same date already in my StartDate column.  I've been working on this for hours, and would really appreciate any help possible.</p>
  
  <p>Thanks!</p>