WPS form Three steps to extract the date of birth from the ID number

As the information management staff, in the data entry, sometimes need to extract the date of birth from the ID card number, if you do not want a manual entry, how to do?

No need to learn the tedious functions, not search the Web template, using the wps form, only three seconds, you can extract from the ID number of the birth date .

Next, we'll use the WPS table to practice.

First, use the WPS form (ET) to open the spreadsheet containing the ID card number.

Second, click Enter the date of birth cell, click FX or perform Insert function. In the Common Formula tab, select Extract ID birthday, click the input box to the right of the ID number below enter parameter input, click the cell that contains the ID number, or enter the cell name of the ID number directly. Click Insert Formula, and a birth date will be extracted successfully!

Third, the implementation of automatic filling, extraction of other people's birth date.

In this way, the date of birth data can be automatically displayed.