DATEFIF function to deal with

Excel version reference: 2010

Assuming that the identity card number in cell A1

1, B1 enter the formula:=DATEDIF (TEXT (19 & MID (A1,7,6), "0-00-00"), TODAY (), "Y") < /p>

2, enter, see the results

Formula simple analysis:

1, DATEDIF function syntax: DATEDIF (start date, end date, "Y"), return to the two date interval of the year

2, TEXT, in accordance with a specific format to return the results

3, MID syntax: MId (character, the location of the start of the interception, the location of the interception, the location of the interception), TODAY (), "Y")

2, TEXT, according to a specific format return results

3, MID syntax: MId (character, the location of the start of the interception, the location of the interception). The beginning of the intercepted position, the number of intercepts), a specific location to intercept the character

4, TODAY (): return to the current system date