代码如下
weeknum=weekDay(DateAdd("d",(-(Day(date))+1),date)) @#the week number of first date of this month
firstdate=DateAdd("d",(-(Day(date))+1),date) @#the first date of this month
ldt_prevmon=dateadd("d",-1,firstdate) @#the last date of prev month
firstdate_lstmon=dateadd("d",(-(Day(ldt_prevmon))+1),ldt_prevmon) @#the first date of last
weekcount=0
for dd=1 to day(ldt_prevmon)
if (weekday(dateadd("d",dd,firstdate_lstmon))=1) then
weekcount=weekcount+1
end if
next
if day(date)<=(8-weekday(firstdate)) then
weekordnew=weekcount+1
ok=year(dateadd("m",-1,firstdate)) & "年" & month(dateadd("m",-1,firstdate)) &"月第" & weekordnew & "周"
else
weekord=int((day(date)-weekday(date))/7+1)
ok=year(Date) & "年" & month(Date) &"月第" & weekord & "周"
end if
延伸阅读
文章来源于领测软件测试网 https://www.ltesting.net/