Spreadsheet: 34721d1232033192-business-week-mo-test-day-to-wk
Sheet: date to week no

 |  |  |  | Calendar | Business
 |  | Date start | date end | Week | Week
enter date | 2008-11-05 00:00:00 | 2008-03-31 00:00:00 | 2008-04-06 00:00:00 | 13 | 0
What is the week number |  | 2008-04-07 00:00:00 | 2008-04-13 00:00:00 | 14 | 1
enter gap calendar week to business week | 13 | 2008-04-14 00:00:00 | 2008-04-20 00:00:00 | 15 | 2
 |  | 2008-04-21 00:00:00 | 2008-04-27 00:00:00 | 16 | 3
 |  | 2008-04-28 00:00:00 | 2008-05-04 00:00:00 | 17 | 4
 |  | 2008-05-05 00:00:00 | 2008-05-11 00:00:00 | 18 | 5
 |  | 2008-05-12 00:00:00 | 2008-05-18 00:00:00 | 19 | 6
 |  | 2008-05-19 00:00:00 | 2008-05-25 00:00:00 | 20 | 7
 |  | 2008-05-26 00:00:00 | 2008-06-01 00:00:00 | 21 | 8
 |  | 2008-06-02 00:00:00 | 2008-06-08 00:00:00 | 22 | 9
 |  | 2008-06-09 00:00:00 | 2008-06-15 00:00:00 | 23 | 10
 |  | 2008-06-16 00:00:00 | 2008-06-22 00:00:00 | 24 | 11
 |  | 2008-06-23 00:00:00 | 2008-06-29 00:00:00 | 25 | 12
 |  | 2008-06-30 00:00:00 | 2008-07-06 00:00:00 | 26 | 13
 |  | 2008-07-07 00:00:00 | 2008-07-13 00:00:00 | 27 | 14
 |  | 2008-07-14 00:00:00 | 2008-07-20 00:00:00 | 28 | 15
 |  | 2008-07-21 00:00:00 | 2008-07-27 00:00:00 | 29 | 16
 |  | 2008-07-28 00:00:00 | 2008-08-03 00:00:00 | 30 | 17
 |  | 2008-08-04 00:00:00 | 2008-08-10 00:00:00 | 31 | 18
 |  | 2008-08-11 00:00:00 | 2008-08-17 00:00:00 | 32 | 19
 |  | 2008-08-18 00:00:00 | 2008-08-24 00:00:00 | 33 | 20
 |  | 2008-08-25 00:00:00 | 2008-08-31 00:00:00 | 34 | 21
 |  | 2008-09-01 00:00:00 | 2008-09-07 00:00:00 | 35 | 22
 |  | 2008-09-08 00:00:00 | 2008-09-14 00:00:00 | 36 | 23
 |  | 2008-09-15 00:00:00 | 2008-09-21 00:00:00 | 37 | 24
 |  | 2008-09-22 00:00:00 | 2008-09-28 00:00:00 | 38 | 25
 |  | 2008-09-29 00:00:00 | 2008-10-05 00:00:00 | 39 | 26
 |  | 2008-10-06 00:00:00 | 2008-10-12 00:00:00 | 40 | 27
 |  | 2008-10-13 00:00:00 | 2008-10-19 00:00:00 | 41 | 28
 |  | 2008-10-20 00:00:00 | 2008-10-26 00:00:00 | 42 | 29
 |  | 2008-10-27 00:00:00 | 2008-11-02 00:00:00 | 43 | 30
 |  | 2008-11-03 00:00:00 | 2008-11-09 00:00:00 | 44 | 31
 |  | 2008-11-10 00:00:00 | 2008-11-16 00:00:00 | 45 | 32
 |  | 2008-11-17 00:00:00 | 2008-11-23 00:00:00 | 46 | 33
 |  | 2008-11-24 00:00:00 | 2008-11-30 00:00:00 | 47 | 34
 |  | 2008-12-01 00:00:00 | 2008-12-07 00:00:00 | 48 | 35
 |  | 2008-12-08 00:00:00 | 2008-12-14 00:00:00 | 49 | 36
 |  | 2008-12-15 00:00:00 | 2008-12-21 00:00:00 | 50 | 37
 |  | 2008-12-22 00:00:00 | 2008-12-28 00:00:00 | 51 | 38
 |  | 2008-12-29 00:00:00 | 2009-01-04 00:00:00 | 52 | 39
 |  | 2009-01-05 00:00:00 | 2009-01-11 00:00:00 | 53 | 40
 |  | 2009-01-12 00:00:00 | 2009-01-18 00:00:00 | 54 | 41
 |  | 2009-01-19 00:00:00 | 2009-01-25 00:00:00 | 55 | 42
 |  | 2009-01-26 00:00:00 | 2009-02-01 00:00:00 | 56 | 43
 |  | 2009-02-02 00:00:00 | 2009-02-08 00:00:00 | 57 | 44
 |  | 2009-02-09 00:00:00 | 2009-02-15 00:00:00 | 58 | 45
 |  | 2009-02-16 00:00:00 | 2009-02-22 00:00:00 | 59 | 46
 |  | 2009-02-23 00:00:00 | 2009-03-01 00:00:00 | 60 | 47
 |  | 2009-03-02 00:00:00 | 2009-03-08 00:00:00 | 61 | 48
 |  | 2009-03-09 00:00:00 | 2009-03-15 00:00:00 | 62 | 49
 |  | 2009-03-16 00:00:00 | 2009-03-22 00:00:00 | 63 | 50
 |  | 2009-03-23 00:00:00 | 2009-03-29 00:00:00 | 64 | 51
 |  | 2009-03-30 00:00:00 | 2009-04-05 00:00:00 | 65 | 52
 |  | 2009-04-06 00:00:00 | 2009-04-12 00:00:00 | 66 | 53
 |  | 2009-04-13 00:00:00 | 2009-04-19 00:00:00 | 67 | 54
 |  | 2009-04-20 00:00:00 | 2009-04-26 00:00:00 | 68 | 55
 |  | 2009-04-27 00:00:00 | 2009-05-03 00:00:00 | 69 | 56
 |  | 2009-05-04 00:00:00 | 2009-05-10 00:00:00 | 70 | 57
 |  | 2009-05-11 00:00:00 | 2009-05-17 00:00:00 | 71 | 58
 |  | 2009-05-18 00:00:00 | 2009-05-24 00:00:00 | 72 | 59
 |  | 2009-05-25 00:00:00 | 2009-05-31 00:00:00 | 73 | 60
 |  | 2009-06-01 00:00:00 | 2009-06-07 00:00:00 | 74 | 61
 |  | 2009-06-08 00:00:00 | 2009-06-14 00:00:00 | 75 | 62
 |  | 2009-06-15 00:00:00 | 2009-06-21 00:00:00 | 76 | 63
 |  | 2009-06-22 00:00:00 | 2009-06-28 00:00:00 | 77 | 64
 |  | 2009-06-29 00:00:00 | 2009-07-05 00:00:00 | 78 | 65
 |  | 2009-07-06 00:00:00 | 2009-07-12 00:00:00 | 79 | 66
 |  | 2009-07-13 00:00:00 | 2009-07-19 00:00:00 | 80 | 67
 |  | 2009-07-20 00:00:00 | 2009-07-26 00:00:00 | 81 | 68
 |  | 2009-07-27 00:00:00 | 2009-08-02 00:00:00 | 82 | 69
 |  | 2009-08-03 00:00:00 | 2009-08-09 00:00:00 | 83 | 70