Public Function GetMonthDays(ByVal dDate As String) As Integer
Dim dNext As Date
Dim dTemp As Date
Dim dCur As Date
dTemp = DateAdd("m", 1, dDate)
dNext = DateSerial(Year(dTemp), Month(dTemp), 1)
dCur = DateSerial(Year(dDate), Month(dDate), 1)
GetMonthDays = DateDiff("d", dCur, dNext)
End Function
Dim dNext As Date
Dim dTemp As Date
Dim dCur As Date
dTemp = DateAdd("m", 1, dDate)
dNext = DateSerial(Year(dTemp), Month(dTemp), 1)
dCur = DateSerial(Year(dDate), Month(dDate), 1)
GetMonthDays = DateDiff("d", dCur, dNext)
End Function
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货