Computer's regional format changes function output

Hello, I'm having trouble with a document that is used in several countries. It was made in the US and when using the computer's region and language format for English (United States), everything works as expected. Once it is changed or opened with Spanish (Mexico) settings, the VBA function does not output as expected. See the code below. I realize it is needlessly complicated, but it should still be counting correctly. The goal is to summarize a much larger table to show how many items in which phases are complete/overdue/upcoming. As soon as I switch the formats, one cell showing a count of 1 immediately changes to 0 upon recalculating. The issue seems to come from the red text line not reporting as true in the countifs function, but I'm not positive. I know that dates are formatted differently in the US (mm/dd/yyyy) vs. Mexico (dd/mm/yyyy), but I would think as long as they all change together, there wouldn't be a problem. I've been staring at this all morning, can anyone offer some advice?

Please Login or Register  to view this content.

Okay, I had a lot of desensitization to do, but I can still recreate it with the attached file. To recreate the issue, open the file and switch your computer's regional format settings (Control Panel > Region and Language > Format tab > Format) from English (US) to Spanish (Mexico) and you'll see the dashboard summary at the top change it's calculation. In my mind, this shouldn't be changing.