Another alternative. I would simplify things by converting dates to a simple number with a math column and use those numbers to build relations linking the date number to the date number in the holiday sheet like @Darren_Murphy described. That way you have full control of the format and it’s completely stable without having to worry about different regional formatting. I explain it in the thread below. Only show the hint component if the relation is not empty. You should only need a math column and a relation column in addition to the date columns you already have.
3 Likes