Challenge #39: Trouble Shooting a Broken Macro

[NancyS]

Fun Challenge!!

[echuong]

Not sure I understand why the posted solution and a lot of submission have -6 years in the filter tool rather than -2 years...can someone explain? I used -2 years because it's a 24m period, and got the same ending answer.

[soha-elghany]

Spoiler

Spoiler

[RobertoEstrada]

My solution uploaded, this one is tricky because some issues are not that easily seen without testing and debuging.

[cgoodman3]

My solution

Spoiler

[johnemery]

Interesting challenge. I hadn't ever debugged a macro before, so that was good practice. Turns out you have to save the macro before any changes flow through to the workflow... I feel silly now for wasting a few minutes wondering why on earth it was still not working ¯\_(ツ)_/¯

Spoiler

[dillon_bok]

Spoiler

[RWvanLeeuwen]

My solution seems to work:

My solution:

Spoiler

[nickjastrzebski]

Spoiler