+ Reply to Thread
Results 1 to 3 of 3

Age calculations...i cant find relevant answers!!

  1. #1
    Registered User
    Join Date
    02-22-2007
    Location
    London
    Posts
    1

    Question Age calculations...i cant find relevant answers!!

    um... im in serious trouble... iv been at this forever but i cant find a solution.

    Im making a system where i am required to calculate age of individuals but iv'e set the format where i have combo boxes where iv'e linked the relevant dates and data onto them.

    Iv'e got a box for Day, Month and Year...
    thats where the problem arises...

    My aim is to make a system, where error is reduced so i'm meant to give the least possible opportunities to the end user where he shall be required to type in any sort of data. All he'll have to do is select from drop downs every where.

    i can't seem to find a formula that will calculate the age from different fields...
    All i seem to find is how age is calculated from a Birthdate in a cell... My problem is as stated above, in different cells...


    Oh, i so require help....
    Please help
    regards

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Take a look at this link on ages

    http://www.cpearson.com/excel/datedif.htm
    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

  3. #3
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    With cell A2 as yesterday and cell B2 as today ...
    Please Login or Register  to view this content.
    HTH
    Carim


    Top Excel Links

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1