How to Use Microsoft Excel Date Difference Function

1. Type a date into a cell. For example, type '10/02/2010' into cell A1.
2. Type a second date into a cell. The second date should be later than the first date. For example, type '10/06/2010' into cell B1.
3. Type an interval into another cell. For example, type 'd' into cell C1.
4. Click on another cell and type the DATEDIF formula, inserting the cell locations of the DATEDIF components. In this example, type '=DATEDIF(A1,B1,C1)'.
5. Press the Enter key for the result. In the example, the result returned will be '4,' indicating there are four days difference between the two dates.