+ Reply to Thread
Results 1 to 4 of 4

Keep month and date but change year to current year and reoccur when new year rolls over.

  1. #1
    Registered User
    Join Date
    08-15-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    3

    Keep month and date but change year to current year and reoccur when new year rolls over.

    I have a list of dates ranging from October 5, 2009 to August 12, 2013 starting in column F3. I need to create a due date starting in column M3. The month and day need to be the same as F3 the year needs to be the current year and change automatically when a new year rolls over. For example if cell F3 is Oct 5, 2009 cell M3 needs to be Oct 5, 2013 and change to Oct 5, 2014 once the new year rolls over.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Keep month and date but change year to current year and reoccur when new year rolls ov

    In M3

    =date(year(today()),month(f3),day(f3))
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    08-15-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Keep month and date but change year to current year and reoccur when new year rolls ov

    Perfect!!!!!!!!! Exactly what I needed. THANKS!!!
    I Wish I would have posted this sooner. I have been searching online for days without success.
    Thank you!

  4. #4
    Registered User
    Join Date
    08-15-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Keep month and date but change year to current year and reoccur when new year rolls ov

    The above formula worked perfectly but I failed to realize that newly added dates with the current year need to generate the due date for the following year. For example if the date is September 4, 2013 the due date needs to generate as September 4, 2014. Is there a way to alter the previous formula to get this result as well?

    THANKS

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If Column A Month and Year = ColumnB Todays Month and Year then send email
    By HACCStaff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:47 AM
  2. [SOLVED] Keeping a date as current year, even though formula determines previous year
    By dropanddrive03 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-28-2013, 08:31 PM
  3. Replies: 4
    Last Post: 07-16-2012, 07:02 AM
  4. Current Year & Month Name, Previous Year & Month Name
    By mithesh in forum Excel General
    Replies: 9
    Last Post: 10-21-2011, 07:00 AM
  5. Macro to change a row of dates in line with current month and year
    By widodude in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2011, 06:50 AM

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