|
- Sub Test()
- Dim rg As Range, arr As Variant, lngRow As Long
- Dim strTemp As String, strSplit() As String
- Dim intYear As Integer, intMonth As Integer, intDay As Integer
-
- Set rg = Sheet1.Range("F1:I5")
- arr = rg
-
- For lngRow = 2 To 3
- strTemp = arr(lngRow, 1)
- strSplit = Split(strTemp, "年")
- arr(lngRow, 2) = Val(strSplit(0))
-
- strTemp = strSplit(1)
- strSplit = Split(strTemp, "月")
- arr(lngRow, 3) = Val(strSplit(0))
-
- strTemp = strSplit(1)
- strSplit = Split(strTemp, "日")
- arr(lngRow, 4) = Val(strSplit(0))
- Next
-
- intDay = (arr(2, 4) + arr(3, 4)) Mod 30
- intMonth = (arr(2, 4) + arr(3, 4)) \ 30
-
- intMonth = intMonth + arr(2, 3) + arr(3, 3)
- intYear = intMonth \ 12
- intMonth = intMonth Mod 12
-
- intYear = intYear + arr(2, 2) + arr(3, 2)
-
- arr(5, 1) = intYear & "年" & intMonth & "月" & intDay & "日"
-
- rg = arr
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|