Thread: "how do I calculate age by using date of birth details"
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Bode via OfficeKB.com Chris Bode via OfficeKB.com is offline
external usenet poster
  
Posts: 47
Default "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

Reply With QuoteReply With Quote