Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAPretty sure I did this in the most convoluted way possible, but at least it's dynamic.
I have solved a similar one before but used a simple technique last time, this time thought to go with Batch Macro.
mm to MM convertion was also a trik!
The solving thrill continues!!!!!!!!!!!!!!!!
Love a good parse and date conversion practice!
Used a macro to update the format for each row using the DateTime tool
