试试这个函数行吗?? Private Function GetDate(ByVal intWeekIndex As Long, ByVal intWeek As Long) As String GetDate = DateAdd("d", (intWeekIndex - 1) * 7 + intWeek, DateSerial(Year(Now), 1, 0)) End Function
那这样行吗?? Private Function GetDate(ByVal intWeekIndex As Long, ByVal intWeek As Long) As String Dim strDateFirst As String strDateFirst = DateSerial(Year(Now), 1, 1) GetDate = DateAdd("d", (intWeekIndex - 1) * 7 + intWeek - Weekday(strDateFirst, vbMonday) + 1, DateSerial(Year(Now), 1, 0)) End Function
Private Function GetDate(ByVal intWeekIndex As Long, ByVal intWeek As Long) As String
GetDate = DateAdd("d", (intWeekIndex - 1) * 7 + intWeek, DateSerial(Year(Now), 1, 0))
End Function
Private Function GetDate(ByVal intWeekIndex As Long, ByVal intWeek As Long) As String
Dim strDateFirst As String
strDateFirst = DateSerial(Year(Now), 1, 1)
GetDate = DateAdd("d", (intWeekIndex - 1) * 7 + intWeek - Weekday(strDateFirst, vbMonday) + 1, DateSerial(Year(Now), 1, 0))
End Function