However, this method is not fully reliable as date numbering varies with different computer operating systems.
For example, the following formula counts the number of days between the dates in cells A1 and B1:Īs we are aware that Excel stores each date as a serial number beginning with January 1, 1900, so we can put numbers corresponding to the dates directly in the formula. We can, on a similar basis, provide cell references. Let’s say we wish to find the number of days between and July 10, 2017. To understand the uses of this function, let’s consider a few examples:
How to use the DATEDIF Function in Excel? Hence, we need to understand thoroughly the syntax of this function. As seen below, Excel doesn’t list this function when we type =DATE in a cell. Interestingly, DATEDIF is a hidden function in Excel. The days and years of the dates are ignored here. It calculates the difference between the months in start_date and end_date. The months and years of the dates are ignored here. It calculates the difference between the days in start_date and end_date. The function returns the number of complete Days in the period. The function returns the number of complete months in the period.ĭifference in complete Days. The function returns the number of complete years in the period.ĭifference in complete months.
This cheat sheet covers 100s of functions that are critical to know as an Excel analyst As a financial analyst Financial Analyst Job Description The financial analyst job description below gives a typical example of all the skills, education, and experience required to be hired for an analyst job at a bank, institution, or corporation. Functions List of the most important Excel functions for financial analysts. The DATEDIF Function in Excel is categorized under Excel Date/Time functions.