|
发表于 2014-9-30 11:19
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim arr, i&, re()
- arr = Range("A1").CurrentRegion.Value
- ReDim re(1 To UBound(arr), 1 To 3)
- re(1, 1) = "出生日期": re(1, 2) = "年龄": re(1, 3) = "性别"
- For i = 2 To UBound(arr)
- re(i, 1) = Mid(arr(i, 1), IIf(Len(arr(i, 1)) = 18, 7, 8), 8)
- re(i, 2) = DateDiff("yyyy", CDate(Format(re(i, 1), "0-00-00")), Date)
- re(i, 3) = IIf(Mid(arr(i, 1), IIf(Len(arr(i, 1)) = 18, 17, 18), 1) Mod 2, "男", "女")
- Next
- Columns("B:D").ClearContents
- Range("B1").Resize(UBound(re), 3) = re
- End Sub
复制代码 |
|