Can your dataset be easily restructured to the following format?
Units PAC Date Base Warranty Date 1 3 3/25/2015 6/25/2015
I think it would make finding the date ranges easier.
If not, I think you will need to employ some of the techniques described here
Attached is an inelegant attempt using the above data format.
190526ref.twbx 23.2 KB