Calculate the date of birth through the ID number. You can obtain the date of birth through the formula [=TEXT(MID(A2,7,8),"0-00-00")] Day, the format is: 010-10-10,
can also be passed [=TEXT(MID(A2,7,8),"00月00日")][=TEXT(TEXT(MID (A2,7,8),"0-00-00"),"e/mm/dd")】Get different formats.
The specific steps are as follows:
1. Enter the formula [=TEXT(MID(A2,7,8),"0-00-00")], that is The birth date format for which the ID card can be obtained is: 2010-10-10
2. Enter the formula [=TEXT(MID(A2,7,8),"0 00月00日")], you can get the birth date format of the ID card: October 10, 2010.
3. Enter the formula [=TEXT(TEXT(MID(A2,7,8),"0-00-00"),"e/mm/dd" )], you can get the birth date format of the ID card: 2010/10/10
For more Excel-related technical articles, please visitExcel Basic TutorialColumn!
The above is the detailed content of How to use excel formula to calculate date of birth. For more information, please follow other related articles on the PHP Chinese website!