Changing a date in text format to sortable date or numeric format
I'm working with an excel file of membership info for a social club and I'm trying to extract each member's birthday so a list can be published in the monthly newsletter. All the data in the excel file are in text format. The dates in particular are in "26-Jul" format. I've tried using the inspector to change these to date format but it always wants to add a year. I don't relish the thought of going through each record and specifying something like "1900" as the year for everyone just to include a year. In the inspector I've tried various date formats, including the "custom" where one can specify which parts of the date are displayed. Quite often the dates now appear as "?" even in Preview. Huh?
So is there a calculation that would accept the "26-Jul" date and transform it into a real date (without the year component?)