How Excel calculates zodiac signs based on age

Tool: excel2007

Purpose: Return the zodiac sign according to age.

Method steps (see screenshot of sample table).

First, create a corresponding table 12 rows according to the age of the zodiac, in this case column a:b.

Age is in column d, and e2 is entered into the formula.

vlookup(mod(d2,12),a:b,2,) formula pull-down copy fill.

The meaning of the formula: find the remainder divided by 12 according to the mod() remainder function.

Then, according to the comparison table a:b, the vlookup() function is used to return the zodiac in column b according to the keyword (remainder, corresponding to column a).

vlookup(if(mod(d2,12)-4＜0,mod(d2,12)＋8,mod(d2,12)－4),a1:b12,2,0)

Note: A1 to A12 are 0 to 11, and B1 to B12 are Rat to Pog.

Column C is empty. d2 enters the year.

If A4 is less than 0, then we use the number A8, otherwise, we use A4.

For example, in 1989, the remainder is 9 after dividing by 12, so we take the number 9 4 5.

In 1959, the remainder after dividing by 12 is 3, 3 4 0, so we take the number 3 8 11.

Then use the vlookup function to match.

This makes it possible to calculate any year. For example, 221 BC is the Year of the Dragon, 0001 is the Year of the Rooster, 1949 is the Year of the Ox, and 2100 is the Year of the Monkey.

The year of birth is given, e.g. a2 is the year of birth (e.g. 1992), then enter in b2

mid("Chickens, monkeys, sheep, horses, snakes, dragons, rabbits, tigers, bulls, rats, pigs, dogs",mod(2221-a2,12)+1,1)

You can calculate your zodiac sign.

If you give the date of birth, e.g. in A2 (e.g. 1992-05-01), enter :

mid("Chickens, monkeys, sheep, horses, snakes, dragons, rabbits, tigers, bulls, rats, pigs, dogs",mod(2221-year(a2),12)+1,1)

Suppose the age is at C2 and the zodiac is placed at D2; Enter the following function in cell d2:

mid("Rats, cows, tigers, rabbits, dragons, snakes, horses, sheep, monkeys, chickens, dogs, pigs",mod(year(today())c2-4,12)+1,1)

Determine a base year, e.g. 2017 is a Rooster.

For example, your age is in cell A1.

choose(12-mod(a1+2017-year(now())1,12),"Chickens","Dogs","Pigs", to be added later).

When it comes to how to calculate someone's age according to their genus, everyone knows that some people ask how to calculate their age through the zodiac? In addition, there are people who want to ask according to the zodiac.

How to calculate people's age, the more detailed the better. Do you know what's going on? In fact, how to calculate his age according to other people's genus, let's take a look at how to calculate age through the zodiac? I hope it can help everyone!

By the time you are 12 years old, you will definitely be the zodiac sign at that time when you were born, according to the 12 zodiac signs.

You can deduce the order. It's mathematically simple, and here's how:

1. First of all, remember the numbers represented by each zodiac sign: Rat 1, Ox 2, Tiger 3, Rabbit 4, Dragon 5, Snake 6, Horse 7, Sheep 8, Monkey 9, Rooster 10, Dog 11, Pig 12

2. For example, this year is the Year of the Horse. People born in the Year of the Horse are 1 year old, 13 years old, 25 years old, etc., and in general, the age of the horse is virtual. The year of the horse constant is 13 7 20

3. It's easy to know. For example, if the year is 10, 20 10 10, then the year born is 10, 22, 34, etc.

4. Another example: calculate the age of the mouse, 20 1 19 years old, the age of the mouse is: the year of the rat in the lunar calendar, 54 years old in the Gregorian calendar, 55 years old in the Gregorian calendar.

Precautions: 1. Calculate the age according to the zodiac, from the moment of the beginning of the spring to the end of the next year before the beginning of the spring is the time to determine the zodiac. These twelve phases.

Rats, cows, tigers, rabbits, dragons, snakes, horses, sheep, monkeys, chickens, dogs, pigs

2. This year is the Year of the Rat, then the year is also the Year of the Rat, and in the same way, it is the Year of the Rat This is the analogy, and the difference between them is the cycle number 12 of the zodiac.

Look at the appearance and guess what age range, and then calculate according to your age zodiac.

Rats, cows, tigers, rabbits, dragons, snakes, horses, sheep, monkeys, chickens, dogs, pigs

12-year-old once a zodiac, you see what age range people are probably in -36 and so on. Then look at what the person belongs to, check the order of the zodiac, and see how many of his genera are ranked. Then extrapolate from the range you have determined.

You can figure it out.

First set a base zodiac, and then add it according to such a base, and add or subtract from the base zodiac... For example, the other party said that it is a sheep, then this year's chicken is the benchmark zodiac, according to the age of the other party and then judged, the older is these few base minus 2 (sheep to chicken difference of two years), the small is to subtract.

First look at his face to estimate the approximate range, and then through the year of the year and the 12-year zodiac card, combined with his own zodiac to get the age.

The above is related to how to calculate age through the zodiac? Related content, is it about how to calculate age through the zodiac? shared. After reading how to calculate someone's age based on their genus, I hope this will help everyone!

First of all, you need to be proficient in memorizing the numbers represented by each zodiac: Rat 1, Ox 2, Tiger 3, Rabbit 4, Wild Qilong 5, Snake 6, Horse 7, Sheep 8, Monkey 9, Rooster 10, Dog 11, Pig 12, the older the ranking in a single round.

For example, 2019 is the Year of the Pig, so the youngest pig is 1 year old, the youngest dog is 2 years old, and the youngest chicken is 3 years old. And so on) the smallest rat is 13 years old.

The different age groups of the same number of pigs are 12 years old for each round. For example, 2019 is the Year of the Pig, so the youngest pig is 1 year old, the next round is 13 years old, the next round is 25 years old, and so on.

Summary. Hello, if you want to calculate the age by the zodiac, you can calculate it according to the year of the zodiac.

Hello, if you want to calculate the age by the zodiac, you can calculate it according to the year of the zodiac.

For example, if this person is a dragon, you can find out all the years of the dragon.

Then analyze which year of the dragon he is more in line with according to the person's physical characteristics. You can know his specific age.

For example, 12, 24, 36, 48

In this way, the age can be roughly calculated.

If there are people of his age, it is better to calculate.

Because the zodiac sign is fixed every year, this can be deduced.

How to check at the age of 65.

Don't you calculate your age by the zodiac<>

65 years old is a year old or a virtual age.

I'm trying to ask about the zodiac by age.

OK, you can calculate its year of birth by the number of years.

In 2022.

His date of birth is 1957.

A.D. 1957, a common year in the Gregorian calendar, a total of 365 days, 53 weeks. The Year of the Rooster in the lunar calendar, leap August, a total of 383 days.

Therefore, this man is a rooster.

Is it subtracting three counterclockwise from the Year of the Rat?

It can be understood so, right.

65 from the year of the zodiac.

What do you mean? It's how to calculate this year.

The natal year is a multiple of 12.

Reaching the age of 72 is the year of birth.

72-65=7 years to go.

Age divided by 12 gives the remainder in order rabbit (0), tiger (1), ox (2), rat (3), pig (4), dog (5), chicken (6), monkey (7), sheep (8), horse (9), snake (10), dragon (11).

For example, if a person is 28 years old, the remainder of the 12 is 4, which is a pig. Note that the age needs to be Zhou Pi Shi Wai years. That is, 0 years old at birth and 1 year old in the second year.

The commonly used method of calculating age in China is calculated according to the calendar years experienced after birth, that is, one year old is counted as one year old when one is born, and one year is added for each subsequent New Year. Generally, it is calculated according to the Lunar New Year, and some are calculated according to the Gregorian calendar. For example, a baby born at the end of December is counted as 1 year old after birth, and 1 year old after January 1 of the Gregorian calendar or the local Chinese New Year.

In this way, the baby is only a few days old, and it is already 2 years old.