SFDB_NETWRKDYS

int __stdcall SFDB_NETWRKDYS(LONG argStartDate,


LONG argEndDate,


LPCTSTR holidays,


LPLONG zDates,


size_t nSize,


WORD wkndNo,


int * retVal 

)

Returns the number of whole working days between two dates (inclusive). Working days exclude weekends and any date identified as a holiday.

Returns
status code of the operation
Return values
NDK_SUCCESSOperation successful
NDK_FAILEDOperation unsuccessful. See SFMacros.h for more details.
See Also
SFDB_ISWRKDY()
Parameters
[in]argStartDateis a serial date number that represents start date
[in]argEndDateis a serial date number that represents finish date
[in]holidaysis a (:_:) separated list of holiday names, calendars, countries or currency
[in]zDatesis an array of holidays dates; each expressed as a serial number (i.e. number of days since 1.1.1970)
[in]nSizeis the number of holiday dates in zDates.
[in]wkndNois the weekend number (1-7,11-17). If missing, the western weekend (i.e. 1, "Saturday, Sunday") is used.
[out]retValis the returned number of work days in the given period.
int SFDB_NETWRKDYS(LONG argStartDate,


LONG argEndDate,


string holidays,


LONG[] zDates,


UIntPtr nSize,


UInt16 wkndNo,


ref int retVal 

)

Returns the number of whole working days between two dates (inclusive). Working days exclude weekends and any date identified as a holiday.

Returns
status code of the operation
Return values
Integer returns whole number of working days between two dates
Parameters
[in]argStartDateis a serial date number that represents start date
[in]argEndDateis a serial date number that represents finish date
[in]holidaysis a (:_:) separated list of holiday names, calendars, countries or currency
[in]zDatesis an array of holidays dates; each expressed as a serial number (i.e. number of days since 1.1.1970)
[in]nSizeis the number of holiday dates in zDates.
[in]wkndNois the weekend number (1-7,11-17). If missing, the western weekend (i.e. 1, "Saturday, Sunday") is used.
[out]retValis the returned number of work days in the given period.
Remarks


Exceptions
Exception Type Condition
None N/A
Requirements
Namespace NumXLAPI
Class SFDBM
Scope Public
Lifetime Static
Package NumXLAPI.DLL
Examples
References
* Hamilton, J .D.; Time Series Analysis , Princeton University Press (1994), ISBN 0-691-04289-6
* Tsay, Ruey S.; Analysis of Financial Time Series John Wiley & SONS. (2005), ISBN 0-471-690740
* D. S.G. Pollock; Handbook of Time Series Analysis, Signal Processing, and Dynamics; Academic Press; Har/Cdr edition(Nov 17, 1999), ISBN: 125609906
* Box, Jenkins and Reisel; Time Series Analysis: Forecasting and Control; John Wiley & SONS.; 4th edition(Jun 30, 2008), ISBN: 470272848