Thread: "how do I calculate age by using date of birth details"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default "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
Reply With QuoteReply With Quote