- 1 Post By akjudge
2nd January 2017, 17:53 #1
Date changes in Excel - Formula required
I plot my blood pressure 3x/day all year long. For example, the dates are shown as:
I'd like very much to block and copy a years worth of dates from my 2016 file showing 2016 and convert all the year dates to 2017. Is there a relatively simple formula in Excel (Win-7/ Office Pro Plus 2010) I can use?
4th January 2017, 21:20 #2
This may not be the most elegant method, but it is easy... And since no one has come to your aid...
Copy the date column (2016 dates) and paste it into your new sheet as column B.
In cell C1 use the formula =B1 + 365 where cell B1 is your first date
Copy the formula in cell C1 down the column (C2, C3, C4, etc) to all the other C-cells
Hide Column B
Now only the new dates show in the new spreadsheet. Not elegant, but easy & fast. (Be sure to copy the format so your dates appear as you want ie 30-Dec-16)
Hope this helps..