Results 1 to 4 of 4

formula needed to add a number of years to a date

Threaded View

  1. #1
    Registered User
    Join Date
    09-18-2013
    Location
    Scarborough,Ontario
    MS-Off Ver
    Excel 2010
    Posts
    3

    formula needed to add a number of years to a date

    I need a formula the will allow me to add years, in number form with decimals, to a birthdate and give me the date the person will turn that age. For example, cell A1 has a dte of birth in it, say July 1/1975 , cell B1 has 25.5 in it, I need the formula for C1 that will tell me, in date form, the day the person turned or turns 25.5

    Thanks
    Last edited by Maryjoefernandez; 09-18-2013 at 11:12 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Age based on DOB; Accounts for leap years. Years old if >2, Months if <2 years old.
    By sharpmel in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-17-2013, 04:20 PM
  2. Replies: 4
    Last Post: 01-07-2013, 08:54 PM
  3. adding years and months
    By sagar in forum Excel General
    Replies: 6
    Last Post: 09-25-2009, 11:32 AM
  4. [SOLVED] Adding years to a date
    By sumitk in forum Excel General
    Replies: 4
    Last Post: 05-18-2006, 04:15 PM
  5. Adding easy
    By cj21 in forum Excel General
    Replies: 5
    Last Post: 02-15-2006, 10:55 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