When parsing JSON which includes a date as YYYY-MM-DD, an invalid syntax error (#NAME?) is returned.
=PARSE(A1,"date") --> #NAME?
Is there a way to cast the type that is returned? Displaying the date as a string would be totally fine in this case.