How to calculate the date of birth of a person from its identity card number on excel.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Calculate Birth Date From An Identity Card Number
0
Discussion
Hey mate. we are not going to let you come back and ask questions if you afterwards remove your question! This forum is intended to help people who come to these pages in the future and is not just a service for you!
don (rep: 1989) Dec 5, '16 at 8:51 pm
Answers
1
You basically do the same thing that Queue did for your previous question but you remove the DATEDIF() part.
=DATE(MID(A1,6,2),MID(A1,4,2),MID(A1,2,2))
(Also, please don't use all caps in your title.)