I am stuck with the task of trying to pull dates from inventory SKUs for over 150k items. There is no way I could ever do this manually one SKU at a time. I was hoping there was a formula I could apply to all of them that would extract the date from the SKUs. Our SKUs all follow a simple format. An example would be NFL-2016-MAY-14-VG-001. The prefix NFL denotes where the item came from. The 2016-MAY-14 is the date the item was listed. This is the piece of data I need to extract as a date into another column of the spreadsheet, preferably in a normal date format. The VG is the condition of the item, and the 001 is simply a number appended to the end to separate it from the next item in the batch of inventory which would have most likely been NFL-2016-MAY-14-VG-002. The hyphens simply separate out everything.

Is there any formula that will be able to look at that cell and say, the date needed to be extracted will be 05/14/2016? This is the hardest excel problem I have ever tried to solve, but obviously my excel skills are limited. Any help on this problem would be EXTREMELY appreciated.