USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The date a worker was hired is written in cell G4. In cell I4, its age must be calculated. What formula do you think can calculate this age.
|
|
=DATE(TODAY())-DATE(G4)
|
|
|
=TODAY(YEAR())-TODAY(G4)
|
|
|
=YEAR(TODAY())-YEAR(G4)
|
|
|
=2021-YEAR(G4)
|
Explanation:
Detailed explanation-1: -The method of calculating age involves the comparison of a person’s date of birth with the date on which the age needs to be calculated. The date of birth is subtracted from the given date, which gives the age of the person. Age = Given date-Date of birth.
There is 1 question to complete.