Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
age formula
Can any one help me figure out if it is possible to have a cell reflect an age based on a date in another cell? For example: cell A3 would equal the age of a person based on the person's birthdate in cell B3 ... How do I get cell A3 to show the age? Thanks for -any- help!! -- Rhiemma ------------------------------------------------------------------------ Rhiemma's Profile: http://www.excelforum.com/member.php...o&userid=34386 View this thread: http://www.excelforum.com/showthread...hreadid=541683 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
age formula
http://www.cpearson.com/excel/datedif.htm
-- Kind regards, Niek Otten "Rhiemma" wrote in message ... | | Can any one help me figure out if it is possible to have a cell reflect | an age based on a date in another cell? | For example: | cell A3 would equal the age of a person based on the person's birthdate | in cell B3 ... How do I get cell A3 to show the age? | | Thanks for -any- help!! | | | -- | Rhiemma | ------------------------------------------------------------------------ | Rhiemma's Profile: http://www.excelforum.com/member.php...o&userid=34386 | View this thread: http://www.excelforum.com/showthread...hreadid=541683 | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
age formula
With the birthdate in cell A1, use this formula: =ROUNDDOWN((TODAY()-A1)/365,0) Format your cell as General with no decimal places to return the Age in full years. Does this work for you? Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=541683 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
age formula
This doesn't account for leap years. For an older person you could easily be 20 days off.
-- Kind regards, Niek Otten "swatsp0p" wrote in message ... | | With the birthdate in cell A1, use this formula: | | =ROUNDDOWN((TODAY()-A1)/365,0) | | Format your cell as General with no decimal places to return the Age in | full years. | | Does this work for you? | | Bruce | | | -- | swatsp0p | | | ------------------------------------------------------------------------ | swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 | View this thread: http://www.excelforum.com/showthread...hreadid=541683 | |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
age formula
Point taken, Nick. Change the formula to: =ROUNDDOWN((TODAY()-A1)/365.25,0) takes care of the leap year issue. DATEDIF requires TWO dates, OP wanted to use just ONE date. OP also didn't indicate how detailed they wanted the response. My answer gives YEARS only...not likely to be negatively impacted by leap years in most people's lifetime. If OP wants age in years, months, days...then your answer is the way to go. Cheers! Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=541683 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
age formula
That did the trick! Thanks!! :) -- Rhiemma ------------------------------------------------------------------------ Rhiemma's Profile: http://www.excelforum.com/member.php...o&userid=34386 View this thread: http://www.excelforum.com/showthread...hreadid=541683 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |