Apologies, I don't think there is anything wrong with the formula after all. I have only just noticed that one of the "Expected CCT Dates" had gone in with the year 1931 (i.e. less than 365 days from now) instead of 2031 (more than 365 days from now).