Challenge #21: Date Reformatting

[EW]

My solution:

Spoiler

I'm sure there are much cleaner ways, but I used multi-row formulas and lots of converting dates and numbers back and forth:

[ksheerasagarm]

Here is the Solution for Challenge 21

[anhtran]

Please find attached for solution, only two tools needed. Thanks.

[EllenB1]

Spoiler

[hgupta239]

Spoiler

[jssandom]

My solution

[smoskowitz]

This one was fun because it was easy and hard. I created the numeric month using the multi-row formula and converted it to month names using the formula -> Switch method. I had to learn how to use the Switch method.

Thanks,

Seth

[sbarnley]

These are quite useful for testing what you've learnt.

[JoshuaGostick]

My solution :)

[Samuel_To]

Hi @GeneR,

Here is my solution.

Thanks and Regards,

Samuel