+ Reply to Thread
Results 1 to 2 of 2

Change years in column to one year

  1. #1
    Registered User
    Join Date
    01-08-2008
    Posts
    1

    Change years in column to one year

    I have a column of formated dates and need to change them all to the same year. i hope this is not too trivial a question.
    thanks chris

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    You could use a helper column, e.g. if your dates are in column A and you want to change them all to 2008 dates then put 2008 in C1 and use this formula in B1 copied down

    =DATE(C$1,MONTH(A1),DAY(A1))

    Note: if any of your your dates are 29th Feb and the year in C1 is not a leap year then that date will become 1st March in the relevant year.

+ 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