This was a great exercise. I would really like to see some comments on the process people used to troubleshoot the macro.
1. Missing close bracket on "Close Date" in Formula(5)
2. Incorrect field renaming for "Open Date" and "Close Date" in Select(17)
3. Target and Source inputs swapped on Append Fields(11) [Looks like other people fixed this by allowing all appends]
4. Action(10) not connected to Text Input(9)
5. Incorrect date formats for conversion in DateTime(15) and DateTime(16)