Thread: How do I calculate a persons age from birth dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default How do I calculate a persons age from birth dates
=DATEDIF(A1,TODAY(),"y")

Regards,
Fred

"Rod Bishop" <Rod wrote in message
...
Wanting a formula to calculate a persons age from birth to today's date

Reply With QuoteReply With Quote