Specific steps for extracting zodiac signs based on date of birth in Excel

Want to quickly determine the zodiac sign based on the date of birth, but don’t know where to start? PHP editor Banana today brings you detailed steps for extracting zodiac signs in Excel. This tutorial will guide you step by step to use Excel functions to easily obtain zodiac information. Continue reading below to learn this practical skill that will allow you to efficiently work with data containing birth dates.

Enter the function formula in the zodiac table [=MID([rat, ox, tiger, rabbit, dragon, snake, horse, sheep, monkey, chicken, dog, pig], MOD(YEAR (the grid where the birthday date is located)-4, 12) 1, 1 )].

The zodiac sign will be automatically displayed.

Finally just fill in the form and you will get all the zodiac signs.

The above is the detailed content of Specific steps for extracting zodiac signs based on date of birth in Excel. For more information, please follow other related articles on the PHP Chinese website!