Contract Expiry Dates

that's right about change only when you open it... however, we can add the same routine somewhere else if you want it to work whenever you enter a date... that's a worksheet change event...