Spreadsheet: 123328d1317579272-visit-due-date-display-datepick
Sheet: Sheet1

SR NO. | CUSTOMER NAME | ESN NO. | CITY | VISIT DUE DATE (=+w2) | DAYS LEFT | LAST VISIT DATE | VISIT | START DATE | nos of visit | 1st visit | 2nd visit | 3rd visit | 4th visit | 5th visit | 6th visit | 7th visit | 8th visit | 9th visit | 10th visit | 11th visit | 12th visit | VISIT DUE DATE | TODAY DATE | VISIT DUE DAYS LEFT
1 | ABC LTD | 1234.23/0800012 | MUMBAI | 2011-10-08 00:00:00 | 6 | 2011-10-08 00:00:00 | M | 2010-12-08 00:00:00 | 12 | 2010-12-08 00:00:00 | 2011-01-08 00:00:00 | 2011-02-08 00:00:00 | 2011-03-08 00:00:00 | 2011-04-08 00:00:00 | 2011-05-08 00:00:00 | 2011-06-08 00:00:00 | 2011-07-08 00:00:00 | 2011-08-08 00:00:00 | 2011-09-08 00:00:00 | 2011-10-08 00:00:00 | 2011-11-08 00:00:00 | 2011-10-08 00:00:00 | 2011-10-02 00:00:00 | 6
2 | ABC LTD | 1234.23/0800012 | MUMBAI | 2011-10-08 00:00:00 | 6 | 2011-10-08 00:00:00 | M | 2010-12-08 00:00:00 | 12 | 2010-12-08 00:00:00 | 2011-01-08 00:00:00 | 2011-02-08 00:00:00 | 2011-03-08 00:00:00 | 2011-04-08 00:00:00 | 2011-05-08 00:00:00 | 2011-06-08 00:00:00 | 2011-07-08 00:00:00 | 2011-08-08 00:00:00 | 2011-09-08 00:00:00 | 2011-10-08 00:00:00 | 2011-11-08 00:00:00 | 2011-10-08 00:00:00 | 2011-10-03 00:00:00 | 5
2 | ABC LTD | 1234.23/0800012 | MUMBAI | 2011-10-08 00:00:00 | 6 | 2011-10-08 00:00:00 | M | 2010-12-08 00:00:00 | 12 | 2010-12-08 00:00:00 | 2011-01-08 00:00:00 | 2011-02-08 00:00:00 | 2011-03-08 00:00:00 | 2011-04-08 00:00:00 | 2011-05-08 00:00:00 | 2011-06-08 00:00:00 | 2011-07-08 00:00:00 | 2011-08-08 00:00:00 | 2011-09-08 00:00:00 | 2011-10-08 00:00:00 | 2011-11-08 00:00:00 | 2011-10-08 00:00:00 | 2011-10-04 00:00:00 | 4
2 | ABC LTD | 1234.23/0800012 | MUMBAI | 2011-10-08 00:00:00 | 6 | 2011-10-08 00:00:00 | M | 2010-12-08 00:00:00 | 12 | 2010-12-08 00:00:00 | 2011-01-08 00:00:00 | 2011-02-08 00:00:00 | 2011-03-08 00:00:00 | 2011-04-08 00:00:00 | 2011-05-08 00:00:00 | 2011-06-08 00:00:00 | 2011-07-08 00:00:00 | 2011-08-08 00:00:00 | 2011-09-08 00:00:00 | 2011-10-08 00:00:00 | 2011-11-08 00:00:00 | 2011-10-08 00:00:00 | 2011-10-05 00:00:00 | 3
2 | ABC LTD | 1234.23/0800012 | MUMBAI | 2011-10-08 00:00:00 | 6 | 2011-10-08 00:00:00 | M | 2010-12-08 00:00:00 | 12 | 2010-12-08 00:00:00 | 2011-01-08 00:00:00 | 2011-02-08 00:00:00 | 2011-03-08 00:00:00 | 2011-04-08 00:00:00 | 2011-05-08 00:00:00 | 2011-06-08 00:00:00 | 2011-07-08 00:00:00 | 2011-08-08 00:00:00 | 2011-09-08 00:00:00 | 2011-10-08 00:00:00 | 2011-11-08 00:00:00 | 2011-10-08 00:00:00 | 2011-10-06 00:00:00 | 2
2 | ABC LTD | 1234.23/0800012 | MUMBAI | 2011-10-08 00:00:00 | 6 | 2011-10-08 00:00:00 | M | 2010-12-08 00:00:00 | 12 | 2010-12-08 00:00:00 | 2011-01-08 00:00:00 | 2011-02-08 00:00:00 | 2011-03-08 00:00:00 | 2011-04-08 00:00:00 | 2011-05-08 00:00:00 | 2011-06-08 00:00:00 | 2011-07-08 00:00:00 | 2011-08-08 00:00:00 | 2011-09-08 00:00:00 | 2011-10-08 00:00:00 | 2011-11-08 00:00:00 | 2011-10-08 00:00:00 | 2011-10-07 00:00:00 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | result show
1 | ABC LTD | 1234.23/0800012 | MUMBAI | 2011-10-08 00:00:00 | 6 | 2011-10-08 00:00:00 | M | 2010-12-08 00:00:00 | 12 | 2010-12-08 00:00:00 | 2011-01-08 00:00:00 | 2011-02-08 00:00:00 | 2011-03-08 00:00:00 | 2011-04-08 00:00:00 | 2011-05-08 00:00:00 | 2011-06-08 00:00:00 | 2011-07-08 00:00:00 | 2011-08-08 00:00:00 | 2011-09-08 00:00:00 | 2011-10-08 00:00:00 | 2011-11-08 00:00:00 | 2011-10-08 00:00:00 | 2011-10-02 00:00:00 | 6