How to extract zodiac sign based on birthday in Excel_A function can help you

Want to know how to extract the zodiac sign based on birthday in Excel? PHP editor Xigua brings a simple method today to teach you how to use a function to easily achieve this goal. Below, we introduce this function in detail and demonstrate how to use it to extract the corresponding zodiac sign from birthday data. Read on to learn how to solve this problem quickly and efficiently in Excel.

First of all, you need to remember the following formula, which is the functional formula for zodiac conversion.

=MID("Rat, Ox, Tiger, Rabbit, Dragon, Snake, Horse, Sheep, Monkey, Chicken, Dog, Pig", MOD(YEAR(A1)-4,12)+1,1)

Please note that here A1 is not a fixed cell, which means that the cell in which the birthday date is located in your form will be filled in that cell.

We take the table below as an example. We enter the formula in the zodiac table and change A1 to B2.

Finally press Enter and the zodiac sign will be displayed. Finally, we can hold down CTRL to fill in the form.

How about it? It’s very simple, so you don’t have to bother to get a calculator to calculate one by one. It doesn’t take too much effort! If you are interested, please go and try it out.

The above is the detailed content of How to extract zodiac sign based on birthday in Excel_A function can help you. For more information, please follow other related articles on the PHP Chinese website!