Google Sheets DD/MM/YYYY Date Format

I use the DD/MM/YYYY date format in my sheets, and I noticed that the Google Sheets Grafana plugin doesn’t recognize dates where the day is greater than 12 - it obviously always treats dates as MM/DD/YYYY.
Even using DATE() formula doesn’t help since my locale settings are set to UK.