Current location - Zhou Gong's Dream Interpretation Network - Horoscope of zodiac signs - I entered a lot of students' information in the form, including birthdays, and now I want to make a program for excel to automatically get out each student constellation.

I entered a lot of students' information in the form, including birthdays, and now I want to make a program for excel to automatically get out each student constellation.

Suppose the birthday is in A 1.

B 1 Enter the following formula to get the constellation:

=LOOKUP( - TEXT(A 1，" mm.d ")，{ 1.0 1. 1，2. 19，3.2 1，4.2 1，5.2 1，6.22，7.23，8.23，9.23， 10

Related articles