Irregular date calculations in large spreadsheet

I've been managing finances for a long time now in Excel. It has grown to 11.500 lines over a period of 20 years en recently my date calculations start to give #VALUE outcomes. The formula in line 1...