Spreadsheet: 136452d1326656785-having-problem-work-on-a-date-to-work-on-1-to-18-week-date-to-work-on-1-to-18-week
Sheet: Sheet1

 |  |  |  |  | New Date &
 |  | Team |  | Week | Date Cancelled | Date | Home |  |  |  | Away |  |  | Season start | [NAME] | No match day | Day
 | 1 | [NAME] |  | 1 |  |  |  | 3 | v | 7 |  | 10 | 1 | 2011-10-13 00:00:00 |  | 2011-11-03 00:00:00 | Thursday |  |  | 2011-10-13 00:00:00
 | 2 | [NAME] |  | 1 |  |  |  | 4 | v | 3 |  | 9 | 2 |  |  | 2011-11-17 00:00:00
 | 3 | [NAME] |  | 1 |  |  |  | 3 | v | 7 |  | 8 | 3 | Monday |  | 2011-12-22 00:00:00
 | 4 | Winning Post |  | 1 |  |  |  | 8 | v | 6 |  | 7 | 4 | Tuesday
 | 5 | Peacock |  | 1 |  |  |  | 2 | v | 8 |  | 6 | 5 | Wednesday
 | 6 | Phoenix Master |  |  |  |  |  |  |  |  |  |  |  | Thursday
 | 7 | Spot on Badgers |  | 2 |  |  |  | 4 | v | 8 |  | 4 | 6 | Friday |  |  |  |  |  | 2011-10-20 00:00:00
 | 8 | [NAME] |  | 2 |  |  |  | 7 | v | 3 |  | 3 | 7 | Saturday
 | 9 | Riley's A |  | 2 | TBA |  |  |  | v |  |  | 2 | 8 | Sunday |  |  |  |  |  | TBA
 | 10 | The [NAME] |  | 2 |  |  |  | 7 | v | 3 |  | 1 | 9
 |  |  |  | 2 |  |  |  | 7 | v | 3 |  | 5 | 10
 |  |  |  | 3 |  |  |  | 2 | v | 8 |  | 8 | 1 |  |  |  |  |  |  | 2011-10-27 00:00:00
 |  |  |  | 3 |  |  |  | 4 | v | 6 |  | 7 | 2
 |  |  |  | 3 |  |  |  | 2 | v | 8 |  | 6 | 3 |  | Hi [NAME]
 |  |  |  | 3 |  |  |  | 4 | v | 6 |  | 5 | 4
 |  |  |  | 3 |  |  |  | 6 | v | 4 |  | 10 | 9 |  | I'm try get formula work on Date Yellow Column I:I. Need get formula work to get a Date. Look below
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Season Start = 13/10/2011
 |  |  |  | 4 |  |  |  | 3 | v | 7 |  | 3 | 5 |  | [NAME] = 4 |  |  |  |  | 2011-11-10 00:00:00
 |  |  |  | 4 |  |  |  | 3 | v | 7 |  | 2 | 6 |  | No Match Day = S5:S7 see a arrow no 03/11/2011
 |  |  |  | 4 |  |  |  | 3 | v | 7 |  | 1 | 7 |  | Day = Thursday
 |  |  |  | 4 |  |  |  | 5 | v | 5 |  | 9 | 8 |  | Week = 1 to 18
 |  |  |  | 4 |  |  |  | 4 | v | 6 |  | 4 | 10 |  | New Date & Cancelled
 |  |  |  | 5 |  |  |  | 6 | v | 4 |  | 6 | 1 |  | Any idea guy.
 |  |  |  | 5 |  |  |  | 6 | v | 4 |  | 5 | 2
 |  |  |  | 5 |  |  |  | 6 | v | 4 |  | 4 | 3
 |  |  |  | 5 | 2012-02-16 00:00:00 |  |  |  | v |  |  | 10 | 8 |  |  |  |  |  |  | 2012-02-16 00:00:00
 |  |  |  | 5 |  |  |  | 6 | v | 4 |  | 7 | 9
 |  |  |  | 6 |  |  |  | 6 | v | 4 |  | 2 | 4
 |  |  |  | 6 |  |  |  | 9 | v | 1 |  | 1 | 5
 |  |  |  | 6 |  |  |  | 9 | v | 1 |  | 9 | 6
 |  |  |  | 6 |  |  |  | 3 | v | 7 |  | 8 | 7
 |  |  |  | 6 |  |  |  | 8 | v | 2 |  | 3 | 10
 |  |  |  | 7 |  |  |  | 4 | v | 6 |  | 4 | 1
 |  |  |  | 7 |  |  |  | 6 | v | 4 |  | 3 | 2
 |  |  |  | 7 |  |  |  | 4 | v | 6 |  | 6 | 8
 |  |  |  | 7 |  |  |  | 2 | v | 8 |  | 5 | 9
 |  |  |  | 7 |  |  |  | 6 | v | 4 |  | 7 | 10
 |  |  |  | 8 |  |  |  | 1 | v | 9 |  | 10 | 2
 |  |  |  | 8 |  |  |  | 6 | v | 4 |  | 1 | 3
 |  |  |  | 8 |  |  |  | 7 | v | 3 |  | 9 | 4
 |  |  |  | 8 |  |  |  | 3 | v | 7 |  | 8 | 5
 |  |  |  | 8 |  |  |  | 9 | v | 1 |  | 7 | 6
 |  |  |  | 9 |  |  |  | 5 | v | 5 |  | 2 | 1
 |  |  |  | 9 |  |  |  | 2 | v | 8 |  | 5 | 7
 |  |  |  | 9 |  |  |  | 4 | v | 6 |  | 4 | 8
 |  |  |  | 9 |  |  |  | 5 | v | 5 |  | 3 | 9
 |  |  |  | 9 |  |  |  | 7 | v | 3 |  | 6 | 10
 |  |  |  | 10 |  |  |  |  | v |  |  | 1 | 10
 |  |  |  | 10 |  |  |  |  | v |  |  | 2 | 9
 |  |  |  | 10 |  |  |  |  | v |  |  | 3 | 8
 |  |  |  | 10 |  |  |  |  | v |  |  | 4 | 7
 |  |  |  | 10 |  |  |  |  | v |  |  | 5 | 6
 |  |  |  | 11 |  |  |  |  | v |  |  | 6 | 4
 |  |  |  | 11 |  |  |  |  | v |  |  | 7 | 3
 |  |  |  | 11 |  |  |  |  | v |  |  | 8 | 2
 |  |  |  | 11 |  |  |  |  | v |  |  | 9 | 1
 |  |  |  | 11 |  |  |  |  | v |  |  | 10 | 5
 |  |  |  | 12 |  |  |  |  | v |  |  | 1 | 8
 |  |  |  | 12 |  |  |  |  | v |  |  | 2 | 7
 |  |  |  | 12 |  |  |  |  | v |  |  | 3 | 6
 |  |  |  | 12 |  |  |  |  | v |  |  | 4 | 5
 |  |  |  | 12 |  |  |  |  | v |  |  | 9 | 10
 |  |  |  | 13 |  |  |  |  | v |  |  | 5 | 3
 |  |  |  | 13 |  |  |  |  | v |  |  | 6 | 2
 |  |  |  | 13 |  |  |  |  | v |  |  | 7 | 1
 |  |  |  | 13 |  |  |  |  | v |  |  | 8 | 9
 |  |  |  | 13 |  |  |  |  | v |  |  | 10 | 4
 |  |  |  | 14 |  |  |  |  | v |  |  | 1 | 6
 |  |  |  | 14 |  |  |  |  | v |  |  | 2 | 5
 |  |  |  | 14 |  |  |  |  | v |  |  | 3 | 4
 |  |  |  | 14 |  |  |  |  | v |  |  | 8 | 10
 |  |  |  | 14 |  |  |  |  | v |  |  | 9 | 7
 |  |  |  | 15 |  |  |  |  | v |  |  | 4 | 2
 |  |  |  | 15 |  |  |  |  | v |  |  | 5 | 1
 |  |  |  | 15 |  |  |  |  | v |  |  | 6 | 9
 |  |  |  | 15 |  |  |  |  | v |  |  | 7 | 8
 |  |  |  | 15 |  |  |  |  | v |  |  | 10 | 3
 |  |  |  | 16 |  |  |  |  | v |  |  | 1 | 4
 |  |  |  | 16 |  |  |  |  | v |  |  | 2 | 3
 |  |  |  | 16 |  |  |  |  | v |  |  | 8 | 6
 |  |  |  | 16 |  |  |  |  | v |  |  | 9 | 5
 |  |  |  | 16 |  |  |  |  | v |  |  | 10 | 7
 |  |  |  | 17 |  |  |  |  | v |  |  | 2 | 10
 |  |  |  | 17 |  |  |  |  | v |  |  | 3 | 1
 |  |  |  | 17 |  |  |  |  | v |  |  | 4 | 9
 |  |  |  | 17 |  |  |  |  | v |  |  | 5 | 8
 |  |  |  | 17 |  |  |  |  | v |  |  | 6 | 7
 |  |  |  | 18 |  |  |  |  | v |  |  | 1 | 2
 |  |  |  | 18 |  |  |  |  | v |  |  | 7 | 5
 |  |  |  | 18 |  |  |  |  | v |  |  | 8 | 4
 |  |  |  | 18 |  |  |  |  | v |  |  | 9 | 3
 |  |  |  | 18 |  |  |  |  | v |  |  | 10 | 6