7,763
社区成员
发帖
与我相关
我的任务
分享
Dim tmp As Date, result As Date
Dim strData As String, strItem() As String
Dim my_year As Integer, my_month As Integer, my_day As Integer
strData = "4 15 A"
strItem = Split(strData, " ")
my_year = Val("201" & strItem(0))
If strItem(2) < "9" Then
my_day = Val(strItem(2))
Else
my_day = Asc(UCase(strItem(2))) - 55
End If
tmp = DateAdd("ww", Val(strItem(1)), my_year & "-1-1")
tmp = tmp - Weekday(tmp, vbTuesday)
my_month = Month(tmp)
result = DateSerial(my_year, my_month, my_day)
MsgBox result