| int __stdcall SFDB_WORKDAY | ( | LONG | argDate, |
| short | days, | ||
| LPCTSTR | holidays, | ||
| LPLONG | zDates, | ||
| size_t | nSize, | ||
| WORD | wkndNo, | ||
| LPLONG | retVal | ||
| ) |
Returns the serial date number that represents the date that falls after the start date by a given number of working days.
- Parameters
[in] argDate is a serial date number that represents a given date [in] days is the number of workdays to advance [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 serial date number after a given number of working days.
| int SFDB_WORKDAY | ( | Long | argDate, |
| short | days, | ||
| string | holidays, | ||
| long[] | zDates, | ||
| UIntPtr | nSize, | ||
| UInt16 | wkndNo, | ||
| ref long | retVal | ||
| ) |
Returns the serial date number that represents the date that falls after the start date by a given number of working days.
- Parameters
[in] argDate is a serial date number that represents a given date [in] days is the number of workdays to advance [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 serial date number after a given number of working days.
- 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
