Dynamic Date Comparison and Cell Population

I am stuck on how to make this work and I could really use some help.  This file will be on a server for others to access as well.   I have a list of products with serial numbers. Each product ha...