How to Use YEARFRAC, INT, and DATEDIF in Excel
In this Excel magic trick video the tutor shows how to use the years worked formula using Yearfrac, Int and Datedif functions. He says that using this trick you can find out how many years some one has worked if we know his starting date and ending date i.e. he shows how to extract the difference in years directly by using formula to calculate it. He shows how to use Yearfrac function which gives the number of years in decimal form. He also shows how to extract integer from the decimal using Int function. He also shows how to use datedif function which directly extracts the number of years between two dates. This video shows how to extract the difference in years between two dates in Microsoft Excel using simple functions.