Days Duration Calculation Based on Criteria

Hi all, here's my scenario. I have four sets of cars that get moved out of my location. They come sporadically throughout the month. Im trying to figure out a formula that would average the turn time on a particular set of cars. Any ideas? Sample Below


8606 05/01/20

340200 05/02/20

8606 05/04/20

340200 05/06/20

8606 05/09/20

340200 05/10/20

8606 05/13/20

340200 05/14/20

8606 05/17/20

340200 05/20/20

8606 05/21/20

8606 05/25/20

5437 05/30/20

340200 06/03/20

340200 06/07/20

340200 06/13/20

340200 06/18/20

340200 06/24/20

400001 06/24/20

340200 07/01/20

5437 07/08/20

340200 07/08/20

340200 07/15/20

400001 07/16/20

340200 07/19/20

340200 07/24/20

340200 07/29/20

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!