DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=INT((TODAY ()-BDATE)/365.20))
|
|
|
=INT(TODAY ()-BDATE)/365.25)
|
|
|
=INT((TODAY ()-BDATE)/365.25))
|
|
|
=INT((DATE()-BDATE)/365.25))
|
Detailed explanation-1: -The first formula that many of us learn is rather appealing in its simplicity: AGE = int((NOW-DOB)/365.25); First determine the number of days from DOB to NOW, then divide by the number of days in a year. Because we have leap years, we use 365.25 as an average number of days in a year.
Detailed explanation-2: -Simply by subtracting the birth date from the current date. This conventional age formula can also be used in Excel. The first part of the formula (TODAY()-B2) returns the difference between the current date and date of birth is days, and then you divide that number by 365 to get the numbers of years.
Detailed explanation-3: -You can also use the YEARFRAC function to calculate the age in Excel (in years) in the specified date range. The YEARFRAC function returns the number of years between the two specified dates and then the INT function returns only the integer part of the value.