作者:黛滢陌陌乄 | 来源:互联网 | 2023-05-20 11:45
1> Gary's Stude..:
要在VBA中使用工作表Workday()函数:
Sub WhyWork()
Dim d1 As Date, wf As WorksheetFunction
Set wf = Application.WorksheetFunction
d2 = wf.WorkDay(Date, 30)
MsgBox Date & vbCrLf & d2
End Sub
`set wf = Application.WorksheetFunction`是天才.不知道为什么我从未想过这个!