Date Format

Hi - beginner here. Attempting to bring in an excel worksheet with standard date format (MM/DD/YYYY) converted in the excel spreadsheet to (YYYY Mmm) using a custom formatting. I cannot get Looker to read my dates in the new format. I have also tried a calculated field in the dimension. Looking to analyze data by month and year, and have it charted chronologically.

0 0 36