USING MICROSOFT EXCEL
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: -=(TODAY()-B2)/365 In this formula, the first part (TODAY()-B2) usually calculates the difference between the current date and the birth date. The second part of the formula helps divide the difference by 365 to get the number of years (i.e., age in years).