+ Reply to Thread
Results 1 to 2 of 2

Age / Date / Number of Years Question

  1. #1
    Registered User
    Join Date
    07-22-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Age / Date / Number of Years Question

    Guys, newbie here. Is there anyway to do following in Excel using formulas? Thanks in advance.
    I have two dates, Date of Birth (DOB) and Date of Hire (DOH). I am trying to come up with a future DATE when TOTAL of both (points) Date of Birth and Date of Hire becomes 65. Also, maximum ‘points’ I can assign to Date of Birth is 60. In other words, Years of Service (YOS) must be at least 5 years.
    Example#1: DOB: 2/12/1971. DOH is: 05/14/2012. 65 Points date will be: 5/14/2024. Person is 42 years old. On 2/12/2024, he will be 53 years old and on 5/14/2024, he will have 12 YOS. Thus on 5/14/2024, he will have 65 points (53+12 = 65).
    Example#2: DOB: 7/28/1953. DOH is: 02/10/2012. 65 Points date will be: 2/10/2016. Person is 59 years old and max points for age given are 60. So on 2/10/2016, he will complete 5 YOS. Thus on 2/10/2016, he will have 65 points.

  2. #2
    Registered User
    Join Date
    07-22-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Age / Date / Number of Years Question

    Clarification: 1 point = 1 year. in my example, I am trying to get to 5/14/2024 using Excel formula, if possible. Person was born on 2/12/1971, so on 2/12/2024, he will be 53 years old, thus 53 points. His date of Hire was 5/14/2012, so on he will have 12 years of service on 5/14/2012 thus 12 points. Later of two dates is 5/14/2024, meaning person would get 65 points on 5/14/2024.
    I am trying to find a 'Later of' Date using two different dates that totals to 65 with maximum points assigned to Date of Birth = 60. I hope this makes sense.

+ 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. [SOLVED] Adding number of years selected from a ComboBox to the storage date
    By Help_Required in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-17-2012, 06:41 AM
  2. Add number of Years to higher date in range
    By Knawl in forum Excel General
    Replies: 2
    Last Post: 11-30-2011, 06:21 AM
  3. Replies: 3
    Last Post: 08-22-2011, 11:58 AM
  4. display number of years based on a date
    By hoser in forum Excel General
    Replies: 2
    Last Post: 03-28-2009, 01:51 PM
  5. Replies: 9
    Last Post: 01-22-2009, 06:01 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