myMonth = month(mydate) '所需月份值
monthFirst = year(mydate) & "-" & month(mydate) & "-1"
Week1 = DatePart("ww",mydate,vbMonday)
Week2 = DatePart("ww",monthFirst ,vbMonday)
myweek = week1-week2
if Weekday(monthFirst,vbMonday)=1 then
myweek = myweek+1
end if
if myweek=0 then
myDate = DateAdd("d",-1,monthFirst)
myMonth = month(mydate) '所需月份值
monthFirst = year(mydate) & "-" & month(mydate) & "-1"
Week1 = DatePart("ww",mydate,vbMonday)
Week2 = DatePart("ww",monthFirst ,vbMonday)
myweek = week1-week2
if Weekday(monthFirst,vbMonday)=1 then
myweek = myweek+1
end if
end if