Calculate days between subtotaled list

Good day, Gurus.

Not sure if this is best accomplished via VBA or Formula, but I know all the smartest people hang out in the Programming forum, so here goes.

In the attached workbook, I have subtotaled a list of parts. I want to add a formula beside the subtotals, under Column C, "Days BO", that subtracts earliest date in column R from the latest date in column R, for each part number.

I have added a simple formula to the attached example that does what I want, but the full sheet will be thousands of lines weekly, with varying part numbers, and different counts. I don't know how to take the count function into account so I can copy a single formula all the way down the sheet.

Thanks in advance for any help you can offer.

Where on your sheet are you talking about? I don't see any date functions other than the dates themselves in column R.

Can you provide several answers for some of the rows on your example sheet and highlight them so we can see what your goal is?

Ah, I see it now in column C. This should take care of it, run this macro to update your column C values:

Please Login or Register  to view this content.