+ Reply to Thread
Results 1 to 5 of 5

Can I use excel to tell me when employees reached anniversary?

  1. #1
    Registered User
    Join Date
    02-10-2016
    Location
    Blaine, mn
    MS-Off Ver
    2007
    Posts
    69

    Can I use excel to tell me when employees reached anniversary?

    Hello!

    I am looking for a way to have Excel alert me to when an employee has reached an anniversary date, in intervals of 5, 10, 15, 20, 25.

    I currently have excel set up to tell me Total Service Year by using the DATEIF function and a Calculation date in an adjacent cell.
    Example: excel2.JPG

    I'd like to see excel tell me based on a calculation date which employees have reached, say 5 years etc like so...

    EXCEL.JPG

    Is this possible?

    Thank you in advance!

  2. #2
    Registered User
    Join Date
    11-20-2015
    Location
    Rogers
    MS-Off Ver
    365
    Posts
    23

    Re: Can I use excel to tell me when employees reached anniversary?

    It would be of tremendous value if you could upload a sample workbook with this information.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,772

    Re: Can I use excel to tell me when employees reached anniversary?

    You could add a Helper column with the formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Then filter on the Helper column = TRUE. That will list all the 5 year anniversary.

    Or maybe add a Pivot Table and filter that

  4. #4
    Registered User
    Join Date
    02-10-2016
    Location
    Blaine, mn
    MS-Off Ver
    2007
    Posts
    69

    Re: Can I use excel to tell me when employees reached anniversary?

    Quote Originally Posted by rlmh06 View Post
    It would be of tremendous value if you could upload a sample workbook with this information.
    I have attached a sample workbook as requested. Thank you!
    Attached Files Attached Files

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365, rarely 2007
    Posts
    12,718

    Re: Can I use excel to tell me when employees reached anniversary?

    Thanks for the upload.

    In the attached is one way to do it with the desired layout.

    Array enter this formula in cell I2. If you arenít familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I changed some of the hire dates so there would be anniversary dates 5, 10, 15 ... etc.
    Dave

+ 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. Replies: 4
    Last Post: 12-12-2018, 12:34 AM
  2. Replies: 10
    Last Post: 07-27-2017, 12:44 PM
  3. Replies: 0
    Last Post: 03-28-2016, 01:35 PM
  4. [SOLVED] Move specific cells to a new sheet when a date is reached or 30 days from being reached
    By Albert Dirk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-26-2016, 04:44 AM
  5. Forecast How Many Employees To Hire Based on Active and Termed Employees
    By Kanook22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-12-2014, 01:19 PM
  6. Replies: 2
    Last Post: 03-11-2013, 09:59 PM
  7. Replies: 4
    Last Post: 11-28-2010, 11:00 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