|
- Sub 有效期()
- arr = Range("h3:i" & [h65536].End(3).Row)
- For i = 1 To UBound(arr)
- d1 = arr(i, 1)
- m1 = Val(Mid(d1, 3, 2))
- If m1 = 1 Then
- m2 = 12: dy = 1
- Else
- m2 = m1 - 1: dy = 2
- End If
- arr(i, 1) = Val("20" & Left(d1, 2)) + dy & "年" & Format(m2, "00") & "月"
- Next
- [o3].Resize(UBound(arr)) = Application.Index(arr, , 1)
- End Sub
复制代码 |
|