Use the DATEDIF function when you want to calculate the difference between two dates. Type the equation you want to calculate. In this example we are going to calculate average selling price.
Start the formula with an sign select a cell enter an operator like or then select another cell.
If the Start_date is greater than the End_date the result will be NUM. Of Calculation Options in Excel Automatic is the default option. Use the DATEDIF function when you want to calculate the difference between two dates. Method 2 - Percentage Formatting Through the Format Cells Dialog Box.