+ Reply to Thread
Results 1 to 4 of 4

formula to get ages

  1. 03-19-2008, 03:44 AM #1
    gfer
    gfer is offline
    Registered User
    Join Date
    03-19-2008
    Posts
    1

    Question formula to get ages

    I am trying to find a formula to convert a list of bithdates to ages can anyone please help.
    Thanks in anticipation
    Reply With QuoteRegister To Reply
  2. 03-19-2008, 06:21 AM #2
    broro183
    broro183 is offline
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243
    hi,

    Check out the list of links at the base of Chip's below page:

    http://www.cpearson.com/Excel/datetime.htm

    hth
    Rob
    Rob Brockett
    Kiwi in the UK
    Always learning & the best way to learn is to experience...
    Reply With QuoteRegister To Reply
  3. 03-19-2008, 09:24 AM #3
    darkyam
    darkyam is offline
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    Have =TODAY() in one cell (say A1)
    Then, by the birthdates, do =A3-$A$1 and use a custom format of y.
    Reply With QuoteRegister To Reply
  4. 03-19-2008, 09:32 AM #4
    oldchippy
    oldchippy is offline
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Quote Originally Posted by gfer
    I am trying to find a formula to convert a list of bithdates to ages can anyone please help.
    Thanks in anticipation
    Hi,

    If you have your date of birth in A1, for example 15/01/2000, then put this in B1

    Please Login or Register  to view this content.
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these
    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)

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