The formatting of that particular CC shows as "26May2022" and it doesn't include spaces so the VBA is not recognising it as a valid date.

Is there a reason you can't change the CC properties to format it with spaces? That would be the easy fix

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia