Home  >  Article  >  Software Tutorial  >  How to extract zodiac sign based on birthday in Excel

How to extract zodiac sign based on birthday in Excel

王林
王林forward
2024-04-25 14:34:11465browse

Do you want to easily extract zodiac signs based on birthday in Excel? PHP editor Strawberry will reveal the secret of this operation to you today. In this article, we will delve into the specific steps of extracting the zodiac sign and teach you step by step how to automatically obtain the corresponding zodiac sign information based on the date of birth. Come learn how to do this with Excel and take your data processing to the next level!

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

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

Please note that A1 here It is not a fixed cell, that is to say, whichever cell the birthday date is in 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.

How to extract zodiac sign based on birthday in Excel How to extract zodiac sign based on birthday in Excel

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

How to extract zodiac sign based on birthday in Excel

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

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete