BUSDAYDIFF
BUSDAYDIFF()
Returns the number of business days between two dates.
| dtDateStart | |
| dtDateEnd |
REMARKS
* You can use the built-in NETWORKDAYS.INTL function to return the number of working days between two dates excluding weekends and holidays.
* You can use the user defined BUSDAYNEXT function to
* You can use the user defined BUSDAYPREVIOUS function to
* You can use the user defined BUSDAYMONTHSTART function to
* You can use the user defined BUSDAYMONTHEND function to
* You can use the user defined BUSDAYYEARSTART function to
* You can use the user defined BUSDAYYEAREND function to
* You can use the user defined BUSDAYSADD function to
* You can use the user defined BUSDAYNTH function to
Public Function BUSDAYDIFF( _
ByVal dtDateStart As Date, _
ByVal dtDateEnd As Date) _
As Date
BUSDAYDIFF = Application.WorksheetFunction.NetworkDays(dtDateStart, dtDateEnd)
End Function
For instructions on how to add this function to a workbook refer to the page under Inserting Functions
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext