+ Reply to Thread
Results 1 to 3 of 3

changing the year of a date

  1. #1
    Registered User
    Join Date
    04-05-2006
    Posts
    15

    changing the year of a date

    Hi Everyone,

    Is there a way I can easily change the year in a list of randon dates??

    I have a table in excel, with date in the first column. I need to be able to change the year of the date, without changing the day and month.
    eg.
    01/12/2005 would need to be changed to 01/12/2006
    04/03/2005 would need to be changed to 04/03/2006
    02/09/2005 would need to be changed to 02/09/2006

    Thanks,
    Julie

  2. #2
    Don
    Guest

    Re: changing the year of a date

    Find and replace 2005 with 2006

    Don

    "zapszipszops" <zapszipszops.268ely_1144980001.4058@excelforum-nospam.com>
    wrote in message
    news:zapszipszops.268ely_1144980001.4058@excelforum-nospam.com...
    >
    > Hi Everyone,
    >
    > Is there a way I can easily change the year in a list of randon dates??
    >
    >
    > I have a table in excel, with date in the first column. I need to be
    > able to change the year of the date, without changing the day and
    > month.
    > eg.
    > 01/12/2005 would need to be changed to 01/12/2006
    > 04/03/2005 would need to be changed to 04/03/2006
    > 02/09/2005 would need to be changed to 02/09/2006
    >
    > Thanks,
    > Julie
    >
    >
    > --
    > zapszipszops
    > ------------------------------------------------------------------------
    > zapszipszops's Profile:
    > http://www.excelforum.com/member.php...o&userid=33217
    > View this thread: http://www.excelforum.com/showthread...hreadid=532852
    >




  3. #3
    Registered User
    Join Date
    04-05-2006
    Posts
    15
    Thanks Don, works great!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1