Thread: Get Date of Birth from a ID Number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lloyd Lloyd is offline
external usenet poster
  
Posts: 41
Default Get Date of Birth from a ID Number
Please help
In Cell A2 6512160515084 in Cell A3 should be 1965/12/16, but if ID Number
starts with 0(0212160515084) should read 2002/12/16

Thanks
Reply With QuoteReply With Quote