Calcuate the closest less than date

Hi All, I am in need of some assistance.   [Charge Activity] File I am working with an imported excel file that lists all labor charges which is broken out by [Charge Date], [Charge Code], and ...