| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a pivot table calculate the difference between two fields | Excel Discussion (Misc queries) | |||
| Calculate Difference between 2 columns in Pivot table | Excel Discussion (Misc queries) | |||
| Calculating difference on Pivot Table Totals | Excel Discussion (Misc queries) | |||
| Pivot Table Subtotals - Difference | Excel Worksheet Functions | |||
| Difference between Averages in a Pivot Table | Excel Worksheet Functions | |||
Threaded Mode
