=MAX(B1, C1, D1)-A1

Excel treats dates as numbers with +1 being an extra day, so this will get you the number of calendar days between submission and the last test. It gets somewhat more complex if you need business days or something, but for calendar days it's really easy.