+ Reply to Thread
Results 1 to 7 of 7

Formula to get Age from Date of Birth

  1. 11-24-2016, 04:11 PM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Formula to get Age from Date of Birth

    Hello:

    I have date of Birth in m/d/yyyy in cell E2, i need formula in cell F2 to get me the age
    Please let me know if you have any questions.
    Thanks.

    Riz
    Reply With QuoteRegister To Reply
  2. 11-24-2016, 04:14 PM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula to get Age from Date of Birth

    Like this...

    =DATEDIF(E2,NOW(),"Y")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  3. 11-24-2016, 04:52 PM #3
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Formula to get Age from Date of Birth

    Or this
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  4. 11-24-2016, 05:26 PM #4
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula to get Age from Date of Birth

    Quote Originally Posted by AlKey View Post
    =YEAR(TODAY())-YEAR(E2)
    If the birthdate was 12/25/2000 that formula returns 16 which is incorrect.
    Reply With QuoteRegister To Reply
  5. 11-24-2016, 07:59 PM #5
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Formula to get Age from Date of Birth

    Hello Tony and Alkey:

    Thanks a lot, works for me.
    Riz
    Reply With QuoteRegister To Reply
  6. 11-24-2016, 08:39 PM #6
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula to get Age from Date of Birth

    You're welcome. Thanks for the feedback!
    Reply With QuoteRegister To Reply
  7. 11-24-2016, 09:48 PM #7
    rahi_feri
    rahi_feri is offline
    Registered User
    Join Date
    09-09-2013
    Location
    Iran
    MS-Off Ver
    Excel 2010
    Posts
    56

    Post Re: Formula to get Age from Date of Birth

    hi
    i know you've got your answer!!....
    Attached Files Attached Files
    Islam = Peace
    Shia = Peace
    Iran = Peace
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. formula to calculate date of birth
    By saravanan1981 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-19-2016, 08:25 AM
  2. Formula for calculating the date a person will be a certain date from their date of birth
    By zander165 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-03-2014, 10:29 AM
  3. Work out Term of Birth by Date of Birth
    By sezza79 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2014, 11:06 AM
  4. Date of birth and pop-up formula/VBA help in Excel
    By ryan-cook in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-29-2013, 12:42 PM
  5. [SOLVED] Date of birth formula
    By bertrand82 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-20-2012, 06:28 AM
  6. Converting Date of Birth to 'Term of Birth'
    By Kungfusal in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-26-2009, 04:12 AM
  7. formula to calculate age using birth date and current date
    By lalah in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2005, 06:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1