Posts tagged DATEDIF

Microsoft Excel Tips: How to calculate the number of days, months or years between two dates

One of the fundamental questions that Excel users may find themselves asking is “How to calculate the number of years, months, or days between two given dates?” This article will show the ways or methods in calculating days, months or years between 2 given dates. There are certain situations when you want to know the number of days, months or years. For instance, in computing rentals or amortizations, in comparing usage or consumption, and many other scenarios, knowing how to calculate the days, months and even years will be vital…. Read More