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
|