Results 1 to 23 of 23

Retirement Eligibility Date based on 3 Variables

Threaded View

  1. #1
    Registered User
    Join Date
    09-06-2014
    Location
    Nevada
    MS-Off Ver
    2003 and 2010
    Posts
    7

    Retirement Eligibility Date based on 3 Variables

    I have been searching forums for help with creating a single cell that returns a result of "Eligible" OR the earliest date that an employee would be eligible for retirement from the organization based on any one of the three variables that are possible. So far I haven't located the help I need, so I joined this forum. Again, I wasn't able to locate the formula I'm seeking on this forum so I apologize if this has been answered somewhere already and would ask to be pointed in that direction. I really like Excel, but am still relatively new at using it. I have 2003 Version at home and 2010 Version at work.

    The elgibility variables are:

    1. 50 years of age AND at least 20 years of service

    2. 55 years of age AND at least 10 years of service

    3. Any Age AND at least 25 years of service

    Since I haven't been able to figure this out, I made three columns in the attached sheet that return a result of True or False. I was able to manually extract the data I was seeking in this arrangement by viewing everyone's age and years of service and then looking back at dates of birth and start date. I'd like to create a final worksheet that automatically displays "Eligible" OR the earliest DATE that an employee would be eligible for retirement so that the time necessary to extract the data is reduced.

    My organization also has another set of criteria for another set of employees:

    1. 60 years of age AND at least 10 years of service

    2. 65 years of age AND at least 5 years of service

    3. Any Age AND at least 30 years of service

    I sincerely appreciate any assistance that can be provided.

    Dale
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using If/And Function to figure out Eligibility of Benefit at a Future Date
    By alauratag in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-02-2014, 01:44 PM
  2. [SOLVED] Need Help with Formula for Eligibility Result Form based on 2 input Variables
    By jlepp06 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2013, 08:08 AM
  3. [SOLVED] Retirement Date Formula
    By adam_crowther in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-03-2013, 07:47 AM
  4. How to find the date of retirement if date of birth is 1-April-1980
    By mmashah in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-30-2012, 03:25 PM
  5. [SOLVED] Calculate my retirement date
    By Joenash in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-08-2012, 01:11 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