How to calculate the date difference in Excel can be done with datedif, but it is hidden

How do you calculate the difference between the two dates? I think many people use the big date to subtract the small date. What we do is the difference between the days of two dates. If you want to accurately get the difference between the year and the month, it is impossible to display it in this way. Then there seems to be no function in Excel for calculating the difference between two dates. In fact, there is a datedif function, but it is hidden by Microsoft. We can not directly call this function through the Function Wizard. We can only call this function by entering the equal sign. Today, we will learn the usage of this function < / P > < p > as shown in the figure below, the function will round the calculation results of two times, and will not round off In this case, the difference between the two years is about 5.6 years, but the result shows that it is 5. Therefore, the function only takes the integer < A= target=_ blank>Continue ReadingDeveloped a “plug and play” solar power generation scheme, and “5B” won a $12 million round a financing

Author: zmhuaxia