How to calculate age using Microsoft Excel

 To calculate age using Microsoft Excel, just use the simple formula DATEDIF. Example would be =DATEDIF(date to compare, current date, "y")


For example, 


Here's the two dates to compare. In selected destination cell, type =DATEDIF(A2,B2,"y")



You'll get the specific age as the result.




Labels: ,

Shortcut to use in Microsoft Office 1

There are shortcuts that you can use in Microsoft Office to fasten your work. You need to press the same keys together. 1) Ctrl + A - to sel...

  • MIN
     Formula MIN is used to search the least value. Example of formula is =MIN(RANGE X:RANGE Y) Example 1 : To find the minimum value of a row ...
  • AVE
    Formula  AVERAGE  is used to search the average value. Example of formula  is  =AVERAGE(RANGE X:RANGE Y) Example 1 : To find the average val...
  • Using '&' in Microsoft Excel
    To connect strings in Microsoft Excel, simply use '&'.   Example : This will return the following results: