Challenge #21: Date Reformatting

[franko003]

My solution.  Looks to be a bit more complex than what was posted.

Spoiler

[HuwHallam]

My solution - nice bit of date conversion practice!

[Jean-Balteryx]

Here is my solution !

[Abell]

Took a slightly simiiar approach to @SeanAdams, however it feels pretty inefficient the way I did it.

[rachelgatto]

Solved. 

[Parul_Kapoor]

Here is the solution

[abinder]

solution attached

[Shifty]

Solution and steps in the spoiler.

Spoiler

Text to columns, select to rename, multi-row formula twice (1) to add a zero and fill down and (2) to convert letters to months.

Also: Iron Man dies in Endgame.  You were warned there were spoilers!

[nickjastrzebski]

Much more difficult than I was expecting. My current solution isn't very dynamic but I'm thinking adding some RegEx to extracting the year may help improve this.

Spoiler