To calculate someone's age in Excel, enter the formula =DATEDIF (A2,TODAY ()," y"), where cell A2 contains the date they were born and "Today" is today's date. Press Enter, and Excel will output ...

To calculate the age, the DATEDIF function, set to check year, determines the number of years between the date in the DOB cell and the current date.

If you want to calculate how much time is left until a certain expiry date, you can use the DATEDIF function. This function returns the difference between two dates in terms of days, months, or years.

Step 4: Another formula you can use to calculate percentage is simply applying the / key in between two cells. For example, to pass a driving theory test, I need to get 80% of the questions correct.