The formula for the age problem is urgent, what is the formula for calculating age?

Age Problem Solution and Algorithm Formula.

The key to solving the problem: the basic rule of "age problem" is: no matter how time changes, the age difference between the two people is always the same, grasp the "age difference".

It is the key to answering the question of age. When analyzing, you can use line diagram analysis to flexibly solve problems by combining problem analysis methods such as sum multiple, difference multiple, and sum difference.

Formula: Age difference Multiplier difference = age (age when the multiple relationship at that time is satisfied).

1. Dad is 42 years old this year, and his daughter is 10 years old this year, and a few years ago his father was 5 times older than his daughter?

Analysis: Asking a few years ago that the father was 5 times the age of the daughter, the first thing to ask was what was the age of the daughter at that time? The father's age is 5 times that of the daughter, the age of the daughter is 1 times, the father is 5 1 4 times more than the daughter, and the age is 42 10 32 (years), correspondingly, you can find out what is 1 times, that is, the age of the daughter at that time.

Solution: (42 10 ) 5 1 ) 32 4 8 (years) 10 8 2 (years) Answer: 2 years ago, my father was 5 times older than my daughter.

2. The father is 36 years older than his son this year, and the father's age is 4 times that of his son after 5 years, how old is his son this year?

Analysis: The father is 36 years older than his son this year and is still 36 years older after 5 years. The father's age is 4 times that of the son, which means that the age of the son is 1 times, and the father is 4 1 3 (times) older than the son, and you can find out how old is 1 times, that is, the age of the son in 5 years, then, how old is it now.

Solution: 36 ( 4 1 ) 36 3 12 (years old) 12 5 7 (years old) Answer: My son is 7 years old this year.

3. The age of the mother and daughter this year is 45 years old, and the mother's age is exactly 4 times that of the daughter in 5 years, how old are the mother and daughter this year?

Analysis: This year, the age of the mother and daughter is 45 years old, and the sum of the age of the mother and daughter in five years is 45 5 2 55 (years), the mother's age is 4 times that of the daughter, the daughter's age is 1 times, and the multiple of the mother-daughter age is 4 1 5 (times), corresponding, you can find the age of the daughter in 5 years, and their age can be found this year.

Solution: (45 5 2 ) 4 1 ) 55 5 11 (years) 11 5 6 (years) 45 6 39 (years).

A: My mother is 39 years old and my daughter is 6 years old.

Three years ago or three years later, the age difference between mother and son is the same, that is, 27 years old, so the age of the son three years ago: 27 (4-1) = 9 (years), this year 9 + 3 = 12 (years old), mother this year: 12 + 27 = 39 (years old).

Other friends, you have solved the wrong equation, let's test it carefully!

The formula is "=datedif(text(mid(a2,7,8),"0000-00-00"),today(),y")“The usage is as follows:

1. Open Excel** with the ID number information.

2. Select cell B2 and enter the formula "datedif(text(mid(a2,7,8),.""0000-00-00"),today(),y""Enter to confirm and you can calculate the age.

3. Hold down the right mouse button in the lower right corner of cell B2, drag down to the last row of data, then release the right mouse button, and select "Copy Cell" from the menu.

4. At this point, all the age information has been calculated.

Introduce. The datedif function is an Excel hidden function, which is not included in the help and insert formulas. Returns the number of years, months, and days intervals between two dates.

The datedif function is often used to calculate the difference between two dates. Contains d, m, y, yd, ym, md.

datedif(start_date,end_date,unit)

Start Date is a date that represents the first or start date in the time period. (The start date must be after 1900).

End Date is a date that represents the last date or end date in the time period.

unit is the return type of the required information.

unit.

Note: The end date must be later than the start date.

Formula "=datedif(text(mid(a2,7,8),"0000-00-00"),today(),y")“

Age, which refers to the length of time a person lives from birth to the time of calculation, is usually expressed in terms of age. Age is a natural sign with a biological and academic basis, and it is an irresistible natural law that a person grows with the passage of time after birth.

While reproducing itself, man is also reproducing his age, which is always composed of individuals of different ages born in different generations. In addition, various demographic phenomena, such as marriage, childbirth, schooling, employment, migration, death, etc., are closely related to the age of each person. Therefore, it is very important to calculate the age correctly.

In addition, the length of time a city or a country exists from the time of its establishment to the time of calculation can also be called "age".

Formula: Age Difference = Age (age when the multiple relationship is satisfied).

Example: The age of the mother and daughter is 45 years old this year, and the mother's age is exactly 4 times that of the daughter in 5 years, how old are the mother and daughter this year?

Analysis: This year's mother-daughter age sum is 45 years old, five years later, the mother-daughter age sum is 45 5 2 55 (years old), the mother's age is 4 times that of the daughter, the daughter's age is 1 times, the mother-daughter age sum is 4 sold to 1 5 (times), correspondingly, you can find the age of the daughter in 5 years, and this year she is late in the age of the people who can be sought.

Solution:

45 5 2 ) 4 1 ) 55 5 11 (years) 11 5 6 (years).

45 6 39 (years old).

A: My mother is 39 years old and my daughter is 6 years old.

Age calculation formula: age, year of year, year of birth.

The customary method of calculating age in China is based on the calendar year experienced after birth, that is, it is counted as one year old at birth, 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. Exact age refers to the number of days elapsed from the date of birth to the date of calculation.

It is a more accurate reflection of how long people actually lived than the age of one year, but it is more cumbersome to summarize statistics.

Other introductions. 1. Imaginary age: The commonly used method of calculating age in China is calculated according to the calendar years experienced after birth.

2. Age: also known as chronological age, refers to the number of years or birthdays experienced from birth to the time of calculation.

3. Exact age: refers to the number of days elapsed from the date of birth to the date of calculation.

The formula for calculating age is: age = current year - year of birth + 1. Age, which refers to the length of time a person has lived from birth to the time of calculation, is usually expressed in years.

Age is a natural marker with a biological basis

A formula is a formula that uses mathematical symbols to express a certain relationship between quantities, such as a law or theorem. It is universal and suitable for all problems of the same kind of relationship. In mathematical logic, a formula is a formal syntax object that expresses a proposition, except that the proposition may depend on the value of the free variable of the formula.

One year old age:

Also known as chronological age, it refers to the number of years or birthdays that have elapsed from birth to the time of calculation. For example, if the census was registered at 0:00 on July 1, 1990, a baby born on December 15, 1989 was 2 years old according to the imaginary age, but in fact it was just over 6 months old and had not yet had a birthday, and the baby should be less than 1 year old according to the age of the child, that is, 0 years old. The age of one year is often 1 2 years younger than the age of the imaginary age, and it is a commonly used method of calculating age in demographics.

1 year - 0 years old at birth, 1 year for each Gregorian birthday.

Exact age:

Refers to the number of days elapsed from the date of birth to the date of calculation. It is a more accurate reflection of how long people actually lived than age of age, but it is rarely used in demographic statistics because it is more cumbersome to aggregate. In practice, people generally do not calculate the exact age on a daily basis, except for babies under the age of 1, especially newborns under 1 month old, who are often calculated on a monthly basis.

1. Calculation of the age of the first year.

1. Enter the formula "=year(today())year(b2)" in cell C2, press enter, and then double-click the lower right corner of the cell to fill it down or drag the lower right corner of the cell to fill it down.

2. Enter the formula "=int((today()-b2) 365)" in cell d2, press enter, and then double-click the lower right corner of the cell to fill it down or drag the lower right corner of the cell to fill it down.

2. Calculation of virtual age.

Add 1 to the formula for the first birthday. Enter the formula "=int((today()-b2) 365)+1" or "=year(today())year(b2)+1" into cell E2, press Enter, double-click the lower right corner of the cell to fill it down, or drag the lower right corner of the cell to fill it down.

1. Take the 2007 version of Excel as an example, open the Excel worksheet and enter the date of birth in cell A2 (for example: 1974-6-5).

2. Calculate the age in cell B2 based on the year of the current time, and enter the function =year() in cell B2, that is, the function of extracting the year.

3. Set the parameters of the year function, move the cursor to the parentheses of the year function, enter the function: today(), the return value of the today function is the current date, and then press the enter key to return the calculation result of the function.

4. We can see that the value returned by the current B2 cell is: 2018, that is, the function year(today()) formula extracts the year of the current date.

5. Since we want to calculate age, we need to use the current date year - the year of the date of birth, so then we enter the minus sign after the year(today( ) function.

6. After entering the minus sign, we want to extract the "year" in the year of birth, so continue to enter the function year(), and then the parameters of the year function are: date of birth, that is, cell A2, as shown in the figure below.

7. After the input is completed, press the Enter key to return the calculation result of the function, and the age is: 44, that is: current year (2018) - birth year (1974) = 44, completed.

How to calculate age in one second based on date of birth?

In Excel**, you know the year, month, and day, and what formula can be used to calculate the age. For example, 1974-6-5, how to calculate age.

From the day of the birthday. For example, if your birthday is January 1, 1991, then you will be 16 years old from January 1 this year, and you will be 16 years old until December 31 this year. Inside.

Again: I've lived in the U.S. for too long, and I don't really understand what a "year old" is. Americans are counted as old.

Another analogy: if your date of birth is May 18, 1980, then you will be 27 years old from May 18 this year to May 17 next year; Cong: You'll be 28 years old from May 18 next year.

OK, I finally understand what "year old" is! Yes, the first year is the "real age algorithm" for Americans.

The elder brother is 9 years older than the younger brother, and the elder brother was 4 times older than the younger brother 2 years ago, how old is the elder brother this year?

1st column, 2nd column.

du The third column is known for the year, month and day.

zhi Today's year, month, day (format as above) dao = (second back column - first column) answer

Case: 1925-7-14 0:00 2010-7-14 0:00The second column is subtracted from the first column in days, divided by Convert to years, and the format of this column can be set as style.

The easiest way is to ask each other directly about the zodiac, and at the same time judge the age of the other party according to the zodiac, of course, you can also ask the other party's age directly, at this time you need to consider the question of virtual age and year old.

In our work and study life, if we ask the other person's age directly, this way may be a bit abrupt and even a little impolite. Sometimes it's not convenient for us to ask the other person's age directly, if we want to judge the other person's age, we can actually express it in a more tactful way.

1. Calculate age through the zodiac.

For the older generation, few people will ask the age directly, and the older generation will not use the time of the Gregorian calendar to calculate the age. If we want to ask the age of the older generation, the easiest way is to ask the other person's zodiac, and if we are similar to the other person's age, we can directly determine the age of the other person through the effect. If the age difference between us and the other party is relatively large, we should estimate which era the other party's zodiac belongs to at this time.

2. Age is calculated by the date of birth.

For relatively young friends, many people will not use the zodiac when reporting their age, at this time we can directly ask each other's date of birth, and judge each other's age according to the date of birth. Because some people like to use virtual years, we need to take this into account when judging age. If the purpose of age is more formal, we need to further verify whether the other party's age is one year old or imaginary age.

3. Try not to ask the other person's age directly.

Personally, I think it's best not to ask someone's age unless it's necessary, because it would be rude. For many adults, many people are not particularly willing to reveal their real age, because it will appear to be very old. If we ask the other person's age because of work needs, we can be generous at this time, there is no need to beat around the bush, we can directly ask the other person's specific age.