+ Reply to Thread
Results 1 to 3 of 3

Excel formula to take an anniversary date to current year

  1. #1
    Forum Contributor
    Join Date
    05-15-2015
    Location
    Orlando, FL
    MS-Off Ver
    Office Standard 2016
    Posts
    269

    Excel formula to take an anniversary date to current year

    Hi everyone,

    I'm needing help with a formula. We have a list of employees with an anniversary date. I'm trying to write a formula that will take the same month and day, but put it to the current year. So for example, cell P4 shows an anniversary date of January 29, 1996. What I would like to do in cell R4 is show the current year anniversary date. Which would be January 29, 2018. How can I do that where this is automatically putting in 2018 as the year? I would like to do this so there is nothing we need to change when its 2019.

    Thanks for the help.

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Excel formula to take an anniversary date to current year

    =DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))

    If Anniversary date is in A1.
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  3. #3
    Forum Contributor
    Join Date
    05-15-2015
    Location
    Orlando, FL
    MS-Off Ver
    Office Standard 2016
    Posts
    269

    Re: Excel formula to take an anniversary date to current year

    Thank you!

+ 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. Vacation tracking from an anniversary date from year to year
    By alejandra92963 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-18-2021, 07:07 PM
  2. [SOLVED] Anniversary Dates for Newsletter Need formula to show new year anytime during month
    By scarames in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-03-2016, 01:11 PM
  3. [SOLVED] Having a Message "Anniversary" on the userform if the HireDate equals Current Date?
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-31-2014, 10:49 AM
  4. [SOLVED] Count current year entries based on date and name formula
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-05-2014, 08:09 PM
  5. Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  6. [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

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