Average the Difference between three dates in a pivot table
 

I am trying to create a table that show me the average of how many days it
takes us from the time we get an inquiry (I input all these dates) to when we
quote it to when we receive an order. I am trying to get a monthly average
and I would like for it to be in a pivot table. Is there any way of doing
this.
All my main data is in a worksheet and all the dates for a specific inquiry
go in the same row, just different cells. Hopefully somebody can help me.

Average the Difference between three dates in a pivot table
 

In your source data, add a column to calculate the days from inquiry to
quote, and another column to calculate time from quote to order.
For example, with inquiry date in column A, quote date in column B, and
order date in column C:

QuoteDays OrderDays
=B2-A2 =C2-B2

Add those fields to the pivot table, and summarize them by Average.

mercedes wrote:
I am trying to create a table that show me the average of how many days it
takes us from the time we get an inquiry (I input all these dates) to when we
quote it to when we receive an order. I am trying to get a monthly average
and I would like for it to be in a pivot table. Is there any way of doing
this.
All my main data is in a worksheet and all the dates for a specific inquiry
go in the same row, just different cells. Hopefully somebody can help me.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html