å¦Âä½Â计ç®Âåºå½ÂÃ¥ÂÂæÂ¥æÂÂå±ÂäºÂå®Âä¹Âæ¶é´段åÂÂ
çÂÂ第å æÂÂæÂÂï¼Â
Function CalculateWeekNo(BeginDate,EndDate,InputDate)
dim wdate(500,8)
z=0
x=0
strlong=len(CStr(inputdate))-9
inputdate=cdate(left(CStr(inputdate),strlong))
for i=cdate(BeginDate) to cdate(EndDate)
ÃÂ ÃÂ if inputdate=i then
ÃÂ ÃÂ x=z
ÃÂ ÃÂ Exit For
ÃÂ ÃÂ end if
ÃÂ ÃÂ if weekday(i)=7 then
ÃÂ ÃÂ z=z+1
ÃÂ ÃÂ end ifÃÂ ÃÂ
next
CalculateWeekNo=x
end Functionxml:namespace prefix = o ns = “urn:schemas-microsoft-com:office:office” /??
[1]