Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"how do I calculate age by using date of birth details"
Help
I am trying to calculate age on the spreadsheet. What cell formula do I need to use to get the age of a person if I have their birth date? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"how do I calculate age by using date of birth details"
Hi,
try this with a birthdate in A1 =DATEDIF(A1,TODAY(),"y") Note that datedif isn't documented in Excel, for help look here http://www.cpearson.com/excel/datedif.htm Mike "mossy 200" wrote: Help I am trying to calculate age on the spreadsheet. What cell formula do I need to use to get the age of a person if I have their birth date? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"how do I calculate age by using date of birth details"
Well, you can use the following formula,
Suppose you have the birth dates in column A then select a cell in any other column and enter following formula =YEAR(TODAY())-YEAR(A1) It will calculate the number of years in between today's date and the supplied date Hope this works Have a nice time Chris ------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200902/1 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"how do I calculate age by using date of birth details"
That may or may not give you the age.
Try it with a birthday of 1/9/81 and todays date and you get a result of 28 but that person isn't 28 ubtil 1/9 Mike "Chris Bode via OfficeKB.com" wrote: Well, you can use the following formula, Suppose you have the birth dates in column A then select a cell in any other column and enter following formula =YEAR(TODAY())-YEAR(A1) It will calculate the number of years in between today's date and the supplied date Hope this works Have a nice time Chris ------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200902/1 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"how do I calculate age by using date of birth details"
Hi,
I personally favor DATEDIF but if you don't like using an undocumented function then =TRUNC(YEARFRAC(A1,TODAY(),1)) Where the birthday is in A1. For this work you could also choose: =DATEDIF(A1,NOW(),"y") or =TRUNC(YEARFRAC(A1,NOW(),1)) -- If this helps, please click the Yes button Cheers, Shane Devenshire "mossy 200" wrote: Help I am trying to calculate age on the spreadsheet. What cell formula do I need to use to get the age of a person if I have their birth date? Thanks |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"how do I calculate age by using date of birth details"
Mike,
Can you drop me an email? I have a problem I want to discuss with you. Email is bob dot phillips at tiscali dot co dot uk -- __________________________________ HTH Bob "Mike H" wrote in message ... That may or may not give you the age. Try it with a birthday of 1/9/81 and todays date and you get a result of 28 but that person isn't 28 ubtil 1/9 Mike "Chris Bode via OfficeKB.com" wrote: Well, you can use the following formula, Suppose you have the birth dates in column A then select a cell in any other column and enter following formula =YEAR(TODAY())-YEAR(A1) It will calculate the number of years in between today's date and the supplied date Hope this works Have a nice time Chris ------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200902/1 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"how do I calculate age by using date of birth details"
Email sent
"Bob Phillips" wrote: Mike, Can you drop me an email? I have a problem I want to discuss with you. Email is bob dot phillips at tiscali dot co dot uk -- __________________________________ HTH Bob "Mike H" wrote in message ... That may or may not give you the age. Try it with a birthday of 1/9/81 and todays date and you get a result of 28 but that person isn't 28 ubtil 1/9 Mike "Chris Bode via OfficeKB.com" wrote: Well, you can use the following formula, Suppose you have the birth dates in column A then select a cell in any other column and enter following formula =YEAR(TODAY())-YEAR(A1) It will calculate the number of years in between today's date and the supplied date Hope this works Have a nice time Chris ------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200902/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
How to calculate "number of months" between two given date? | Excel Worksheet Functions |