Average the Difference between three dates in a pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Average Problem 2
Average of % in pivot table 1
Average of Subtotals in Pivot Table 0
Pivot Table Calculation 4
Pivot table average 1
Multiple Pivot Tables based on the same data 3
Pivot table Average with [h]:mm format 5
PIVOT TABLE SUM OF AVERAGES 1

Back
Top