Thread: How do I calculate the age of a person from their ID no.?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tracey Tracey is offline
external usenet poster
  
Posts: 78
Default How do I calculate the age of a person from their ID no.?
I have a work sheet which provides the ID number of a person (the first 6
digits are the birth date of the person YYMMDD). Another column requests
age. How can I create a formula that will automatically calculate the age of
the person as at the current date?
Reply With QuoteReply With Quote