PdcApplication.NoOfWorkingDays

Declaration

NoOfWorkingDays(StartDate, EndDate as Date) as integer

Description

Returns the number of working days between two dates.

Notes

This function calculates the number of working days between two dates. The calculation is based on the table of non working days.

Code example

This example returns the number of working days of the following seven days from now. Normally the answer is 5.

  msgbox pdc.NoOfWorkingDays(Date(), Date() + 7)

Availability

Available since April 2014 (from version 4.3)