Like Tree1Likes
  • 1 Post By akjudge

Thread: Date changes in Excel - Formula required

  1. #1
    OkinawaBob is offline New Member
    Join Date
    Apr 2014
    Posts
    2

    Default Date changes in Excel - Formula required

    I plot my blood pressure 3x/day all year long. For example, the dates are shown as:

    30-Dec-16
    30-Dec-16
    30-Dec-16
    31-Dec-16
    31-Dec-16
    31-Dec-16

    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?
    Thanx.

  2. #2
    akjudge is offline New Member
    Join Date
    Jan 2014
    Posts
    1

    Default

    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..
    HappyAndyK likes this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Log in

Log in

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22