Calculate Birth Date From An Identity Card Number

0

How to calculate the date of birth of a person from its identity card number on excel.

Answer
Discuss

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: 1482) Dec 5, '16 at 8:51 pm
Add to Discussion

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.)

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login