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: