calulate the age using DOB present in c12 cell
Question
calulate the age using DOB present in c12 cell
Solution
To calculate the age using the DOB present in cell C12, you can use the DATEDIF function in Excel. Here are the steps:
-
Click on the cell where you want the age to be calculated. Let's say this is cell D12.
-
Type the following formula:
=DATEDIF(C12, TODAY(), "Y") -
Press Enter.
This formula calculates the difference in years between the date in cell C12 and the current date. The "Y" in the formula stands for years.
Please note that the date in cell C12 should be in a format that Excel recognizes as a date.
Similar Questions
Age pyramid A,B and C indicates
Present ages of 'A' and 'B' are in the ratio 3:5, respectively. Present ages of 'B' and 'C' are in ratio 2:3, respectively. If five years hence from now, age of 'A' will be 54% less than that of 'C', then find the present age of 'C'. a. 45 years b. 20 years c. 30 years d. 48 years
Which code is best to provide the age of each students recorded in the tblstudents?Group of answer choicesSELEC YEAR(NOW()) - YEAR(BDATE) FROM TBLSTUDENTSSELECT STUDNAME AS "NAME OF THE STUDENT", YEAR(NOW()) - YEAR(BDATE) FROM TBLSTUDENTSSELECT YEAR(NOW()) - YEAR(BDATE) AS AGE FROM TBLSTUDENTSSELECT STUDNAME AS "NAME OF THE STUDENT", YEAR(NOW()) - YEAR(BDATE) AS AGE FROM TBLSTUDENTS
Copy df in df1a and calculate the scaled age for each row in df1a based on theirage relative to the range of ages in the dataset. Store the results in a new column namedScaled_Age.
Complete the main method in the AgeChecker class by Declaring and instantiating a Scanner objectPrint the "What is your age?" message to the consoleDeclaring the int age variable, assigning it the output of nextInt()If the value of age is greater than 40 then print "You are old". Otherwise, print "You are young"
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.