Spreadsheet: 274877d1383245831-if-then-statements-forum-help
Sheet: Before

Appt Made Date | Day | Appt Made date [NAME] | Appt Date | Delta | Days | Desired results in work days | Appt Time
2013-09-27 00:00:00 |  |  | 2013-09-27 08:10:00 |  |  | 1 | 2013-09-27 08:10:00
2013-09-27 00:00:00 |  |  | 2013-09-27 08:30:00 |  |  | 1 | 2013-09-27 08:30:00
2013-09-23 00:00:00 |  |  | 2013-09-23 08:30:00 |  |  | 1 | 2013-09-23 08:30:00
2013-09-05 00:00:00 |  |  | 2013-09-05 08:30:00 |  |  | 1 | 2013-09-05 08:30:00
2013-09-26 00:00:00 |  |  | 2013-09-26 08:30:00 |  |  | 1 | 2013-09-26 08:30:00
2013-09-24 00:00:00 |  |  | 2013-09-24 08:30:00 |  |  | 1 | 2013-09-24 08:30:00
2013-09-04 00:00:00 |  |  | 2013-09-04 08:30:00 |  |  | 1 | 2013-09-04 08:30:00
2013-09-27 00:00:00 |  |  | 2013-09-27 08:40:00 |  |  | 1 | 2013-09-27 08:40:00
2013-09-06 00:00:00 |  |  | 2013-09-06 08:50:00 |  |  | 1 | 2013-09-06 08:50:00
2013-09-27 00:00:00 |  |  | 2013-09-27 08:50:00 |  |  | 1 | 2013-09-27 08:50:00
2013-09-20 00:00:00 |  |  | 2013-09-20 09:00:00 |  |  | 1 | 2013-09-20 09:00:00
2013-09-30 00:00:00 |  |  | 2013-09-30 09:00:00 |  |  | 1 | 2013-09-30 09:00:00
2013-09-16 00:00:00 |  |  | 2013-09-16 09:00:00 |  |  | 1 | 2013-09-16 09:00:00
2013-09-05 00:00:00 |  |  | 2013-09-05 09:30:00 |  |  | 1 | 2013-09-05 09:30:00
2013-09-26 00:00:00 |  |  | 2013-09-26 09:30:00 |  |  | 1 | 2013-09-26 09:30:00
2013-09-26 00:00:00 |  |  | 2013-09-26 09:30:00 |  |  | 1 | 2013-09-26 09:30:00
2013-09-04 00:00:00 |  |  | 2013-09-04 09:50:00 |  |  | 1 | 2013-09-04 09:50:00
2013-09-18 00:00:00 |  |  | 2013-09-18 09:50:00 |  |  | 1 | 2013-09-18 09:50:00
2013-09-19 00:00:00 |  |  | 2013-09-19 09:55:00 |  |  | 1 | 2013-09-19 09:55:00
2013-09-19 00:00:00 |  |  | 2013-09-19 09:55:00 |  |  | 1 | 2013-09-19 09:55:00
2013-09-26 00:00:00 |  |  | 2013-09-26 10:00:00 |  |  | 1 | 2013-09-26 10:00:00
2013-09-19 00:00:00 |  |  | 2013-09-19 10:00:00 |  |  | 1 | 2013-09-19 10:00:00
2013-09-24 00:00:00 |  |  | 2013-09-24 10:00:00 |  |  | 1 | 2013-09-24 10:00:00
2013-09-16 00:00:00 |  |  | 2013-09-16 10:10:00 |  |  | 1 | 2013-09-16 10:10:00
2013-09-09 00:00:00 |  |  | 2013-09-09 10:10:00 |  |  | 1 | 2013-09-09 10:10:00
2013-09-30 00:00:00 |  |  | 2013-09-30 10:10:00 |  |  | 1 | 2013-09-30 10:10:00
2013-09-11 00:00:00 |  |  | 2013-09-11 10:10:00 |  |  | 1 | 2013-09-11 10:10:00
2013-09-16 00:00:00 |  |  | 2013-09-16 10:15:00 |  |  | 1 | 2013-09-16 10:15:00
2013-09-19 00:00:00 |  |  | 2013-09-19 10:20:00 |  |  | 1 | 2013-09-19 10:20:00
2013-09-19 00:00:00 |  |  | 2013-09-19 10:20:00 |  |  | 1 | 2013-09-19 10:20:00
2013-09-27 00:00:00 |  |  | 2013-09-27 10:30:00 |  |  | 1 | 2013-09-27 10:30:00
2013-09-06 00:00:00 |  |  | 2013-09-06 10:30:00 |  |  | 1 | 2013-09-06 10:30:00
2013-09-27 00:00:00 |  |  | 2013-09-27 10:30:00 |  |  | 1 | 2013-09-27 10:30:00
2013-09-30 00:00:00 |  |  | 2013-09-30 10:30:00 |  |  | 1 | 2013-09-30 10:30:00
2013-09-19 00:00:00 |  |  | 2013-09-19 15:40:00 |  |  | 1 | 2013-09-19 15:40:00
2013-09-11 00:00:00 |  |  | 2013-09-11 15:40:00 |  |  | 1 | 2013-09-11 15:40:00
2013-09-30 00:00:00 |  |  | 2013-09-30 15:50:00 |  |  | 1 | 2013-09-30 15:50:00
2013-09-10 00:00:00 |  |  | 2013-09-10 15:55:00 |  |  | 1 | 2013-09-10 15:55:00
2013-09-27 00:00:00 |  |  | 2013-09-27 16:00:00 |  |  | 1 | 2013-09-27 16:00:00
2013-09-27 00:00:00 |  |  | 2013-09-27 16:00:00 |  |  | 1 | 2013-09-27 16:00:00
2013-09-18 00:00:00 |  |  | 2013-09-18 16:05:00 |  |  | 1 | 2013-09-18 16:05:00
2013-09-04 00:00:00 |  |  | 2013-09-04 16:05:00 |  |  | 1 | 2013-09-04 16:05:00
2013-09-30 00:00:00 |  |  | 2013-09-30 16:15:00 |  |  | 1 | 2013-09-30 16:15:00
2013-09-09 00:00:00 |  |  | 2013-09-09 16:30:00 |  |  | 1 | 2013-09-09 16:30:00
2013-09-24 00:00:00 |  |  | 2013-09-24 16:30:00 |  |  | 1 | 2013-09-24 16:30:00
2013-09-16 00:00:00 |  |  | 2013-09-17 08:10:00 |  |  | 3 | 2013-09-17 08:10:00
2013-09-16 00:00:00 |  |  | 2013-09-17 08:10:00 |  |  | 3 | 2013-09-17 08:10:00
2013-09-26 00:00:00 |  |  | 2013-09-27 08:50:00 |  |  | 3 | 2013-09-27 08:50:00
2013-09-24 00:00:00 |  |  | 2013-09-25 08:50:00 |  |  | 3 | 2013-09-25 08:50:00
2013-09-24 00:00:00 |  |  | 2013-09-25 08:50:00 |  |  | 3 | 2013-09-25 08:50:00
2013-09-09 00:00:00 |  |  | 2013-09-10 08:55:00 |  |  | 3 | 2013-09-10 08:55:00
2013-09-12 00:00:00 |  |  | 2013-09-13 08:55:00 |  |  | 3 | 2013-09-13 08:55:00
2013-09-16 00:00:00 |  |  | 2013-09-17 09:00:00 |  |  | 3 | 2013-09-17 09:00:00
2013-09-19 00:00:00 |  |  | 2013-09-20 09:00:00 |  |  | 3 | 2013-09-20 09:00:00
2013-09-24 00:00:00 |  |  | 2013-09-25 09:00:00 |  |  | 3 | 2013-09-25 09:00:00
2013-09-25 00:00:00 |  |  | 2013-09-26 09:00:00 |  |  | 3 | 2013-09-26 09:00:00
2013-09-23 00:00:00 |  |  | 2013-09-24 09:05:00 |  |  | 4 | 2013-09-24 09:05:00
2013-09-05 00:00:00 |  |  | 2013-09-06 09:05:00 |  |  | 4 | 2013-09-06 09:05:00
2013-09-03 00:00:00 |  |  | 2013-09-04 09:05:00 |  |  | 4 | 2013-09-04 09:05:00
2013-09-19 00:00:00 |  |  | 2013-09-20 09:10:00 |  |  | 4 | 2013-09-20 09:10:00
2013-09-26 00:00:00 |  |  | 2013-09-27 09:10:00 |  |  | 4 | 2013-09-27 09:10:00
2013-09-12 00:00:00 |  |  | 2013-09-13 14:40:00 |  |  | 4 | 2013-09-13 14:40:00
2013-09-19 00:00:00 |  |  | 2013-09-20 14:40:00 |  |  | 4 | 2013-09-20 14:40:00
2013-09-12 00:00:00 |  |  | 2013-09-13 14:40:00 |  |  | 4 | 2013-09-13 14:40:00
2013-09-04 00:00:00 |  |  | 2013-09-05 15:40:00 |  |  | 4 | 2013-09-05 15:40:00
2013-09-25 00:00:00 |  |  | 2013-09-26 15:40:00 |  |  | 4 | 2013-09-26 15:40:00
2013-09-11 00:00:00 |  |  | 2013-09-12 15:40:00 |  |  | 4 | 2013-09-12 15:40:00
2013-09-05 00:00:00 |  |  | 2013-09-06 16:00:00 |  |  | 4 | 2013-09-06 16:00:00
2013-09-11 00:00:00 |  |  | 2013-09-12 16:00:00 |  |  | 4 | 2013-09-12 16:00:00
2013-09-25 00:00:00 |  |  | 2013-09-26 16:00:00 |  |  | 4 | 2013-09-26 16:00:00
2013-09-17 00:00:00 |  |  | 2013-09-18 16:05:00 |  |  | 5 | 2013-09-18 16:05:00
2013-09-18 00:00:00 |  |  | 2013-09-19 16:05:00 |  |  | 5 | 2013-09-19 16:05:00
2013-09-25 00:00:00 |  |  | 2013-09-26 16:05:00 |  |  | 5 | 2013-09-26 16:05:00
2013-09-04 00:00:00 |  |  | 2013-09-05 16:05:00 |  |  | 5 | 2013-09-05 16:05:00
2013-09-25 00:00:00 |  |  | 2013-09-26 16:20:00 |  |  | 5 | 2013-09-26 16:20:00
2013-09-11 00:00:00 |  |  | 2013-09-12 16:30:00 |  |  | 5 | 2013-09-12 16:30:00
2013-09-16 00:00:00 |  |  | 2013-09-18 08:10:00 |  |  | 7 | 2013-09-18 08:10:00