Challenge #21: Date Reformatting

[StanleyKinnok_Chan]

switch function is cool, but I think it is too hard to type the formula due to the string,  and not easy to read as well.

I preferred to eliminate the conflicted cases, then find&replace the value at once.

[oliver_inthavong]

My solution:

Spoiler

[ChrisCode007]

hello, This is my answer

[mgaronson]

Did not want to 'hard-code' Month Name. Tried a different approach using RecordID. This solution assumes all 12 months are included in order for each year. Love the Mod function!

[KathrynMW]

My solution for this challenge

Spoiler

 

[dwstada]

my solution, I hope there is something more convenient to change the months than a giant multirow formula expression

[lucascs]

Solved

[alexhenson]

Spoiler

[Linas]

Spoiler

[SamYX]