In excel, you can use the formula =(TODAY()-A2)/365 to calculate the age. Open the excel form and enter the date of birth to be calculated. Then select cell B2, enter the formula =(TODAY()-A2)/365, and press enter to get the age.

First, open the Excel spreadsheet program and enter the main interface of Excel spreadsheet program operation. Then select the cell input function "= datedif (C2Today ()" Y2 ") in the main interface of Excel spreadsheet program.

Create a new excel, and input the data of year, month and day into the excel table to calculate the age. Enter the calculation formula of age =DATEDIF(A2, TODAY (), y). How to change your age at birth? Drag the area where the formula is required. Excel extracts age from birth date.

Excel finds the age by birth date: first, open the Excel table file, right-click the cell that needs the result, and click "Cell Format" in the menu. Set the cell format to Number and the number of decimal places to 0.

Find the average age from the date of birth known in the database.

1, select top 3 * from studendorderbyagestop 3 indicates the top three students, and orderbyageASC indicates that the first one is the youngest.

2. The 2.year function can be used to calculate the age according to the date of birth in SqlServer.

3. Navigate to cell E2 and enter "= (Today () -D2)/365". Pressing the Enter key will display the age. Move the cursor to the lower right corner of the cell. When the cursor changes to a black cross, move the cursor down and select all the tables for which you want to calculate the age.

How to calculate the age according to the date of birth in access

1, year(date)-year([ date of birth]) to get the age.

2. Use this function: =Nz((Year(Date())-Year([ date of birth])), 0)&; Years old. Microsoft Office Access: Microsoft Office Access is a relational database management system released by Microsoft.

Among them, if he was born in 2000- 10- 10, according to this statement, he is 8 years old. If the landlord wants to set a birthday, he will be one year older, that is, the person born in 2000- 10- 10 was born in 2009-65438.

4. You can use expressions in Access to calculate a person's age. For example, you can enter a birthday in one control of a form and then display the number of years after that date in another control. The following steps provide specific operation skills, including creating a form, inserting two text boxes and entering an expression.

5 years. Let's translate the explanation first: calculate the difference between the date of birth and the date of death, and then divide this difference by 365. Replace/divide with \ symbol to get the largest integer without decimal point. It is easy to understand what it means after translation. I hope I can help you.

6. Right-click the field row in the first column of the query design grid, select the "Generator" option, open the "Expression Builder" dialog box, enter the expression "m _ age: max ([age ])-Min([ age])" in the dialog box, and click the "OK" button.

How to calculate the age corresponding to the date of birth?

1. Step 1: Open the Excel form on the computer and enter the page to be edited. Step 2: Select the age column. Step 3: Click the right mouse button and select the cell format. Step 4: Select the column of numbers, then select the category of values, change the decimal places to 0, and finally click OK.

2. In EXCEL, if you know the date of birth, you can use Today function and YEAR function to calculate the age. The method steps are as follows: Open the EXCEL table to be operated, enter "=YEAR(TODAY())-YEAR(A 1)" in the function editing box above any blank position, and press enter.

3. First open the Excel table to be edited and enter the editing page. Then enter the formula "=(today()-C28)/365" in the cell after the date of birth, and press enter to confirm. Then, you can see the results in the pop-up window.

There is only the date of birth in a database, how to get the age?

1, use the date function yearYear(Now())-year([ date of birth]).

2. The 2.year function can be used to calculate the age according to the date of birth.

3. The 3.year function can be used to calculate the age according to the date of birth in SqlServer. The steps are as follows: there is a student table with the following data, in which birthdays are listed as birthday columns. To calculate everyone's age, you can use the following statement: the query result is as follows, and the age calculation result appears: the relational database system introduced by Microsoft Corporation of the United States.

4. First, create a blank database, create a table in the database and insert data, as shown in the figure below, and then enter the next step. Secondly, after completing the above steps, select "Create" in the menu bar, and then select "Query Design" button. The window displaying the table will pop up, as shown in the figure below, and then enter the next step.

There is only the date of birth in a database, how to get the age?

Year (now ()) -year([ date of birth]).

The year function can be used to calculate the age according to the date of birth.

The year function can be used to calculate the age according to the date of birth in SqlServer. The steps are as follows: there is a student table with the following data, in which birthdays are listed as birthday columns. To calculate everyone's age, you can use the following statement: the query result is as follows, and the age calculation result appears: the relational database system introduced by Microsoft Corporation of the United States.

To give you an idea, you need to first convert the date of birth into to_char format, and then subtract it from the current date.

The date of birth is known in the database, and the year function is used to find the average age. According to the relevant public information, it is very convenient to calculate the age according to the date of birth with the year function. Function, mathematical terminology.

In EXCEL, if you know the date of birth, you can use Today function and YEAR function to calculate the age. The method steps are as follows: Open the EXCEL table to be operated, enter "=YEAR(TODAY())-YEAR(A 1)" in the function editing box above any blank position, and press enter.