You can use the DATEDIF function or the NETWORKDAYS function to calculate date duration in Excel. The DATEDIF function calculates the difference between two dates in calendar units (days ...

The starting point is the price information for each date on which you're producing an average. First, calculate the difference between the two prices for each date. You'll need to pick one set of ...