comparing data by dates

Good morning .. I will try and describe my challenge as best as possible ..hope it will make sense.    1. I have two dates from which I derive a DATEDIFF per category called the Lead Time 2. There...