Sub test()
r = 1
For i = DateValue("2011-1-7") To DateValue("2011-12-31") Step 7
r = r + 1
Cells(r, 2) = Format(i, "mm.dd-") & Format(i + 6, "mm.dd")
If Month(i) = Month(i - 7) Then m = m + 1 Else m = 1
Cells(r, 3) = Format(i, "m月第") & m & "周"
Next
End Sub
Sub test()
r = 1
For i = DateValue("2011-1-7") To DateValue("2011-12-31") Step 7
r = r + 1
Cells(r, 2) = Format(i, "mm.dd-") & Format(i + 6, "mm.dd")
If Month(i) = Month(i - 7) Then m = m + 1 Else m = 1
Cells(r, 3) = Format(i, "m月第") & m & "周"
Next
End Sub