| 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_SUCCESS Operation successful NDK_FAILED Operation unsuccessful. See SFMacros.h for more details.
- See Also
- SFDB_ISWRKDY()
- Parameters
[in] argStartDate is a serial date number that represents start date [in] argEndDate is a serial date number that represents finish date [in] holidays is a (:_:) separated list of holiday names, calendars, countries or currency [in] zDates is an array of holidays dates; each expressed as a serial number (i.e. number of days since 1.1.1970) [in] nSize is the number of holiday dates in zDates. [in] wkndNo is the weekend number (1-7,11-17). If missing, the western weekend (i.e. 1, "Saturday, Sunday") is used. [out] retVal is 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] argStartDate is a serial date number that represents start date [in] argEndDate is a serial date number that represents finish date [in] holidays is a (:_:) separated list of holiday names, calendars, countries or currency [in] zDates is an array of holidays dates; each expressed as a serial number (i.e. number of days since 1.1.1970) [in] nSize is the number of holiday dates in zDates. [in] wkndNo is the weekend number (1-7,11-17). If missing, the western weekend (i.e. 1, "Saturday, Sunday") is used. [out] retVal is 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
