Comment by unsupp0rted

Ever tried to normalize/parse a list of dates in Excel? It takes a formula a mile long, and I’ve never gotten it to work quite right.

E.g.

01/15/2024

1/15/2024

1/15/24

01/03/2024

1/3/2024

1/3/24

Unless you write something in VBscript or whatever Excel uses now, it’s a nightmare.