Challenge #21: Date Reformatting

[AshwiniChezhiyan]

Solution Attached

[Steven_Pocoroba2]

See that some of the earlier solutions used a complex formula matching, I think a tile tool works well + a table

[KatyP]

Here is my solution. I notice that the posted solution also has a very very long if statement for the months. I took the same approach but I'm wondering if there is a simpler way? 

[mbonora]

My solution.

[calampert]

My solution:

[JoeS]

I went with 2 multi-row formulas as many others did.

Ended up with slightly different syntax, but similar effect.

Spoiler

[johnemery]

I spent some time looking for a function similar to Excel's TEXT to convert the "J, F, M..." to "Jan, Feb, Mar, ..." but eventually settled on a lengthy IF statement, which seems to be the common strategy. Some of the other solutions are interesting, and good examples of other ways to think about the problem.

Spoiler

[DavidThorpe]

My solution:

Spoiler

Used RegEx parse to split the Date on (.)(.*), filled rows, tiled and used a lookup table to generate Month strings 

[DavidThorpe]

My solution:

Spoiler

Used RegEx parse to split the Date on (.)(.*), filled rows, tiled and used a lookup table to generate Month strings