How to automatically fill in gender and date of birth according to ID number in Excel?

1, you can use the mid function to extract the representative number, which is the penultimate number of the ID number in the excel table;

2.mod function can be used to distinguish odd or even numbers. If the result is 0, it is even, and if the result is 1, it is odd.

3. You can use the if function to fill in the gender, if it is odd, it is a boy, if it is even, it is a girl;

4. You can also nest the functions of mid, mod and if, fill in the gender at one time, and automatically fill in the above information.