Challenge #21: Date Reformatting

[lyon_abido]

Spoiler

A bit of a brute force strategy I think, but I got it. Fun challenge! 

[jerviss53]

Solution Attached

[CeliaC_Silje]

Spoiler

[dougbaron]

Spoiler

[carol2021]

Solution

[Archie_bos]

here is my solution

[katestrohm]

1. Formula 1: Left([Date], 1)

    Formula 2: IF Length([Date]) >2 THEN Right([Date], 2) ELSE "" ENDIF

2. Multi-Row Formula for the Year column: IF IsEmpty([Year]) THEN [Row-1:Year] ELSE [Year] ENDIF

3. Multi-Row Formula to create a month number/count column: [Row-1:Month number]+1

4. Switch function to replace numbers with month abbr: Switch([Month number],Null(),1,'Jan',2,'Feb',3,'Mar',4,'Apr',5,'May',6,'Jun',7,'Jul',8,'Aug',9,'Sep',10,'Oct',11,'Nov',12,'Dec')

5. Select tool to hide a month number/ count column

[Spurs]

Spoiler

[nbendoff]

solution

[bhrmitra]

Solution Attached !!