I have a date range such as "9/15/2016-9/15/2017" in cell A1. Is there a way to easily advance the date range by a year? For example, I would like "9/15/2017-9/15/2018" to appear in cell B1, "9/15/2018-10/15/2018" to appear in cell C1, and so on. Usually I would just add "+1" to the previous cell, but this does not work with a range of dates in a single cell. I am using Excel 2010.