|
楼主 |
发表于 2013-9-21 10:20
|
显示全部楼层
本帖最后由 ranrise 于 2013-9-21 10:27 编辑
以上两位的代码都不行啊,可能是我表达不太清楚,我贴上全部代码:
Function WORKDAYS(Firstday, Lastday)
arr = Array("2013-1-1", "2013-1-2", "2013-1-3") '法定节假日在此指定
brr = Array("2013-1-4", "2013-1-5") '调休日在此指定(指周六、周日因调休而成工作日)
For h = LBound(arr) To UBound(arr)
arrw = arrw & ":" & Format(arr(h), "yyyymmdd")
Next h
For h = LBound(brr) To UBound(brr)
Brrw = Brrw & ":" & Format(brr(h), "yyyymmdd")
Next h
Myweekday = Empty
For h = CDbl(Firstday) To CDbl(Lastday) + 0.01
W = Weekday(h, 2)
If W >= 1 And W <= 5 Then
p = Format(h, "yyyymmdd")
If InStr(arrw, p) = Empty Then
Myweekday = Myweekday + 1
End If
Else
p = Format(h, "yyyymmdd")
If InStr(Brrw, p) <> Empty Then
Myweekday = Myweekday + 1
End If
End If
Next h
WORKDAYS = Myweekday
End Function
也就是说我不想代码中来写”2013-1-1", "2013-1-2"--------这么多的日期值,我是想把这些日期放在工作表的
单元格中,在代码中只是简单引用一下(比如像A1:A100这类的多简单!)。
|
|