Just a quick question...so I know which solution will work for you!
Are you creating an extract from this, when using in Tableau, or keeping it running Live against the Excel?
The plan is to run it live. Thanks
As it turns out it doesn't actually matter (I forgot Excel now supports DATEPARSE!)
So the formula to turn this to a date is
DATEPARSE('dd-MMM-yy', '01-' + LEFT([Month],3)+'-'+TRIM(RIGHT([Month],2)))
The first part 'dd-MMM'yy' tells Tableau what format to expect (notice I've added a 01 for the day, as the date needs to have a day part to it). I then use the String manipulations to turn your string into that format. btw you may not need the TRIM...I just seem to have ended up with an extra (space) character somewhere!!
you might also find this useful
This is how I knew that 3 capital Ms (MMM) was the month format of the 1st 3 letter format of a month.
Attached (9.3) is an example running live off an Excel.
Hope that does the trick and makes sense, but let me know if not.
Thank you so much! Working like a charm. Spent so much time trying to figure this out.