Help with formula across 2 spreadsheets

[Rossc0]

Good morning all,

Im trying to get an idea of the average time it takes for a quote to turn into an order.

We have a quote record & job book.

Im going to put a new tab on the job book to show how long each job took from quote stage.

Column D on the quote record is the date it was issued.
Column B on the job book is the order date.

Any odeas on formulas and also any suggestions on a graph or similar to show the average would be great

[AliGW]

Is this across workBOOKS or workSHEETS?

There are instructions at the top of the page explaining how to attach your sample workbook.

[Rossc0]

Is this across workBOOKS or workSHEETS?

There are instructions at the top of the page explaining how to attach your sample workbook.

Thank you, examples now attached! this is workbooks

[JeteMc]

My idea is to keep both spreadsheets in the same workbook.
On the Job No. spreadsheet column E displays the quote dates using: =IFERROR(INDEX('Quote No.'!D$2:D$23,MATCH(D2,'Quote No.'!A$2:A$23,0)),"")
Column F calculates the number of days to turn a quote into a job using: =IF(E2="","",B2-E2)
Cell calculates the average number of days using: =AVERAGE(F2:F22)
Let us know if you have any questions.