If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel formula for year calc.
I'm new to excel, I have all the information set up on
excel with name, address, date of birth, etc. what I need is the formula to calculate age in excel. I have no idea how to figure this out. Any help would be appreciated. Thanks, Bobby |
#2
|
|||
|
|||
Excel formula for year calc.
-----Original Message----- I'm new to excel, I have all the information set up on excel with name, address, date of birth, etc. what I need is the formula to calculate age in excel. I have no idea how to figure this out. Any help would be appreciated. Thanks, Bobby . Hi, Try this on the cell where you want to display the age, type in =dateif("A1",today(),"Y"). "A1" is where you have your date of birth info. Sai S. Vy |
#3
|
|||
|
|||
Excel formula for year calc.
Bobby, the DATEDIF worksheet function is just what you need. See Sai S. Vy's
post for a simple example of its use. For more information on this function, look he http://www.cpearson.com/excel/datedif.htm (scroll down to "Calculating a Person's Age"). -- DDM "DDM's Microsoft Office Tips and Tricks" Visit us at www.ddmcomputing.com "Bobby" wrote in message ... I'm new to excel, I have all the information set up on excel with name, address, date of birth, etc. what I need is the formula to calculate age in excel. I have no idea how to figure this out. Any help would be appreciated. Thanks, Bobby |
#4
|
|||
|
|||
Excel formula for year calc.
Sai S. Vy - IS150 wrote:
-----Original Message----- I'm new to excel, I have all the information set up on excel with name, address, date of birth, etc. what I need is the formula to calculate age in excel. I have no idea how to figure this out. Any help would be appreciated. Thanks, Bobby . Hi, Try this on the cell where you want to display the age, type in =dateif("A1",today(),"Y"). "A1" is where you have your date of birth info. Sai S. Vy Just tried this I think it should be datedif not dateif gls858 |
Thread Tools | |
Display Modes | |
|
|