Using the YEARFRAC function one can count the number of years between two dates. Alternatively the MINUS function can help you to count the number of days between two dates. We will also look at the TODAY function which will perpetually change your counts if you are counting the number of years or days from today.