Spreadsheet: 205879d1357925904-figuring-dates-with-many-variables-140-reminderfile-1-
Sheet: Sheet1

Ticket Number | Created Date | Deadline | Reminder 1 | Reminder 2 | Reminder 3 |  | Holiday | Country
301251 | 2013-01-02 17:00:00 |  |  |  |  |  | 2013-01-01 00:00:00 | Mexico |  |  |  |  | 2013-01-01 00:00:00
301313 | 2013-01-03 08:43:01.760000 |  |  |  |  |  | 2013-02-04 00:00:00 | Mexico |  |  |  |  | 2013-01-07 00:00:00
301375 | 2013-01-03 11:03:20.767000 |  |  |  |  |  | 2013-03-18 00:00:00 | Mexico |  |  |  |  | 2013-01-21 00:00:00
301394 | 2013-01-03 11:45:22.477000 |  |  |  |  |  | 2013-03-28 00:00:00 | Mexico |  |  |  |  | 2013-02-04 00:00:00
301442 | 2013-01-03 12:33:37.867000 |  |  |  |  |  | 2013-03-29 00:00:00 | Mexico |  |  |  |  | 2013-02-12 00:00:00
301448 | 2013-01-03 12:39:03.393000 |  |  |  |  |  | 2013-05-01 00:00:00 | Mexico |  |  |  |  | 2013-02-18 00:00:00
301473 | 2013-01-03 13:11:51.963000 |  |  |  |  |  | 2013-09-16 00:00:00 | Mexico |  |  |  |  | 2013-02-23 00:00:00
301554 | 2013-01-03 16:07:02 |  |  |  |  |  | 2013-11-18 00:00:00 | Mexico |  |  |  |  | 2013-03-18 00:00:00
301739 | 2013-01-04 10:54:31.930000 |  |  |  |  |  | 2013-12-25 00:00:00 | Mexico |  |  |  |  | 2013-03-28 00:00:00
302066 | 2013-01-07 11:11:21.213000 |  |  |  |  |  | 2013-01-01 00:00:00 | Canada |  |  |  |  | 2013-03-29 00:00:00
302195 | 2013-01-07 15:10:19.163000 |  |  |  |  |  | 2013-02-18 00:00:00 | Canada |  |  |  |  | 2013-03-31 00:00:00
302500 | 2013-01-08 12:22:49.490000 |  |  |  |  |  | 2013-03-29 00:00:00 | Canada |  |  |  |  | 2013-04-01 00:00:00
302614 | 2013-01-08 15:23:54.747000 |  |  |  |  |  | 2013-04-01 00:00:00 | Canada |  |  |  |  | 2013-04-13 00:00:00
 |  |  |  |  |  |  | 2013-05-20 00:00:00 | Canada |  |  |  |  | 2013-05-01 00:00:00
 |  |  |  |  |  |  | 2013-07-01 00:00:00 | Canada |  |  |  |  | 2013-05-20 00:00:00
 |  |  |  |  |  |  | 2013-08-05 00:00:00 | Canada |  |  |  |  | 2013-05-21 00:00:00
 |  |  |  |  |  |  | 2013-09-02 00:00:00 | Canada |  |  |  |  | 2013-05-27 00:00:00
 |  |  |  |  |  |  | 2013-10-14 00:00:00 | Canada |  |  |  |  | 2013-05-30 00:00:00
 |  |  |  |  |  |  | 2013-11-11 00:00:00 | Canada |  |  |  |  | 2013-06-03 00:00:00
 |  |  |  |  |  |  | 2013-12-25 00:00:00 | Canada |  |  |  |  | 2013-07-01 00:00:00
 |  |  |  |  |  |  | 2013-12-26 00:00:00 | Canada |  |  |  |  | 2013-07-04 00:00:00
 |  |  |  |  |  |  | 2013-01-01 00:00:00 | USA |  |  |  |  | 2013-07-28 00:00:00
 |  |  |  |  |  |  | 2013-01-21 00:00:00 | USA |  |  |  |  | 2013-08-05 00:00:00
 |  |  |  |  |  |  | 2013-02-18 00:00:00 | USA |  |  |  |  | 2013-08-10 00:00:00
 |  |  |  |  |  |  | 2013-03-29 00:00:00 | USA |  |  |  |  | 2013-08-19 00:00:00
 |  |  |  |  |  |  | 2013-04-13 00:00:00 | USA |  |  |  |  | 2013-09-02 00:00:00
 |  |  |  |  |  |  | 2013-05-27 00:00:00 | USA |  |  |  |  | 2013-09-07 00:00:00
 |  |  |  |  |  |  | 2013-06-03 00:00:00 | USA |  |  |  |  | 2013-09-16 00:00:00
 |  |  |  |  |  |  | 2013-07-04 00:00:00 | USA |  |  |  |  | 2013-10-12 00:00:00
 |  |  |  |  |  |  | 2013-09-02 00:00:00 | USA |  |  |  |  | 2013-10-14 00:00:00
 |  |  |  |  |  |  | 2013-10-14 00:00:00 | USA |  |  |  |  | 2013-11-02 00:00:00
 |  |  |  |  |  |  | 2013-11-11 00:00:00 | USA |  |  |  |  | 2013-11-11 00:00:00
 |  |  |  |  |  |  | 2013-11-28 00:00:00 | USA |  |  |  |  | 2013-11-15 00:00:00
 |  |  |  |  |  |  | 2013-12-25 00:00:00 | USA |  |  |  |  | 2013-11-18 00:00:00
 |  |  |  |  |  |  | 2013-01-01 00:00:00 | MCA |  |  |  |  | 2013-11-28 00:00:00
 |  |  |  |  |  |  | 2013-01-07 00:00:00 | MCA |  |  |  |  | 2013-12-24 00:00:00
 |  |  |  |  |  |  | 2013-02-23 00:00:00 | MCA |  |  |  |  | 2013-12-25 00:00:00
 |  |  |  |  |  |  | 2013-03-28 00:00:00 | MCA |  |  |  |  | 2013-12-26 00:00:00
 |  |  |  |  |  |  | 2013-03-29 00:00:00 | MCA |  |  |  |  | 2013-12-31 00:00:00
 |  |  |  |  |  |  | 2013-05-01 00:00:00 | MCA
 |  |  |  |  |  |  | 2013-05-21 00:00:00 | MCA
 |  |  |  |  |  |  | 2013-07-28 00:00:00 | MCA
 |  |  |  |  |  |  | 2013-08-10 00:00:00 | MCA
 |  |  |  |  |  |  | 2013-08-19 00:00:00 | MCA
 |  |  |  |  |  |  | 2013-10-14 00:00:00 | MCA
 |  |  |  |  |  |  | 2013-11-11 00:00:00 | MCA
 |  |  |  |  |  |  | 2013-12-25 00:00:00 | MCA
 |  |  |  |  |  |  | 2013-01-01 00:00:00 | Brazil
 |  |  |  |  |  |  | 2013-02-12 00:00:00 | Brazil
 |  |  |  |  |  |  | 2013-03-29 00:00:00 | Brazil
 |  |  |  |  |  |  | 2013-03-31 00:00:00 | Brazil
 |  |  |  |  |  |  | 2013-04-01 00:00:00 | Brazil
 |  |  |  |  |  |  | 2013-05-01 00:00:00 | Brazil
 |  |  |  |  |  |  | 2013-05-30 00:00:00 | Brazil
 |  |  |  |  |  |  | 2013-09-07 00:00:00 | Brazil
 |  |  |  |  |  |  | 2013-10-12 00:00:00 | Brazil
 |  |  |  |  |  |  | 2013-11-02 00:00:00 | Brazil
 |  |  |  |  |  |  | 2013-11-15 00:00:00 | Brazil
 |  |  |  |  |  |  | 2013-12-24 00:00:00 | Brazil
 |  |  |  |  |  |  | 2013-12-25 00:00:00 | Brazil
 |  |  |  |  |  |  | 2013-12-31 00:00:00 | Brazil