How to extract the birthday of ID card with excel function

You can use the mid function to extract the birthday in the ID card in Excel.

Software version: Office20 13

The method is as follows:

1. Use the function to extract the birthday in A 1:

2. The input formula is as follows:

3. Get the date of birth: