As we know, 18 The 8 digits starting from the 7th digit of the ID number represent the date of birth. The year of birth is four digits from the seventh place, so we can extract the year of birth with the MID function. Double-click B2 and enter the formula:
=MID(A2，7，4)
To ask the age, you need to subtract the year of birth from the current year. We can use the YEAR function to get the current year. For example, enter =YEAR(NOW ()) to return the current year 20 14.
Combine the above two parts to get the final formula of B2:
=YEAR(NOW())-MID(A2，7，4)
Next, let's see how to judge men and women.
18 digits of the ID number 17 digits are numbers for judging gender, with odd numbers representing men and even numbers representing women. First of all, we still use the MID function to extract the17th digit and input the formula:
= MID(2， 17， 1)
Then we use the MOD function (MOD function is the function of taking the remainder) to take the remainder of bit 17 and divide it by 2. If the remainder is 0, the number 17 is even, that is, the ID card is female; Conversely, if the remainder is 1, the ID card is male. We nest the IF function as follows:
= if (mod (mid (a2, 17, 1), 2), "male", "female")
seven
The above formula applies to 18 digit ID number. If there is an ID number with 15 digits, you can use the formula to upgrade it to 18 digits, and then use the above formula to calculate it.
Extended data:
Mathematics is a basic subject (meaning that mathematics is coherent. If you don't learn a link well, you may not understand it with some knowledge in white, so if you have a poor foundation, you must make up the foundation first! )
If the foundation is good, it will be very simple.
Preview first, and mark what you don't understand ~
Remind yourself that the teacher needs to listen carefully when talking about this problem!
Then listen carefully in class,
In fact, class is a process of understanding. If students have a good understanding ability, they usually master what the teacher teaches after class. Mathematics focuses on understanding. If you don't understand in class, you need to ask, or buy a reference book to read for yourself.
Practice is necessary.
Because only by practice can we know what we don't understand and what we master.
And some knowledge points look simple, but they are not easy to use. Doing exercises also helps you to use formulas flexibly.
And most importantly, doing more exercises can improve your problem-solving ability and speed. At school, some students often can't finish the test paper, that is, the speed of solving problems is too slow; Part of it is that I didn't know how to solve the problem until I handed in the test paper. This is the problem of problem-solving ability. So we should not only master knowledge, but also improve the speed and ability of solving problems!
So the most important thing to improve mathematics is to practice more. But it's not sea training, it's tempering.
If you don't understand at last, be sure to ask!
Review is also essential, so consolidate it if you have time. You can also write down the tips you have got from doing problems for many years, which will help save time in solving problems! Because you should try to take time out to check during the exam. At least make sure it's finished! And if it's too difficult, leave it alone and see what you can do first. Because if you don't do it, you lose points. No, wrong again. Not worth the candle!