前几天我问过，今天写出来了！！

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 Function