How to calculate the age of a specific day from the ID number in excel (such as 2013,31)?

For example, if the ID number is in column A, it is in b1= datedif (text (mid (a1,7, len (A 1)/2- 1), "0-00-00"), "20"

Excel basic formula

1, the formula for finding the content of heavy summer is =IF(COUNTIF(A:A, A2)> 1, "heavy summer",).

2. Calculate the age formula according to the date of birth: = trunc((360 days (H6, "2009/8/30"). False /360, の)

3. The formula for calculating the birth date of18 digit ID number is = Concatenate (mid (e2 e2,7,4), "/,mid (e2,0//kloc-0,2)"/,mid (e2./kloc-0,3,2).

4. Enter the system to automatically extract the gender from the input ID number. You can enter the following formula: = if (len (C2) = 15. If (mod (mid (C2. 15, 1), 2) = 1, "male" and "female".