Dates functions
- DTROLL: roll a given date to nearest workday using a given convention.
- DTNETWORKDAYS: number of workdays between two dates.
- DTWORKDAY: date that falls after a number of working days.
- DTADVANCE: date that falls after a given period (e.g. '1-month', '3 -weeks').
- DTBOWEEK: date that falls on first work day in a given week.
- DTEOWEEK: date that falls on last work day in a given week.
- DTGetNWKDY: date of the n-th weekday in a month
|
|
Holidays functions
- ISHOLIDAY: examines a given date whether it falls on a holiday.
- ISWORKDAY: examines a given date whether it falls on non-weekend or non-holidays.
- ISWEEKEND: examines a given date whether it falls on a weekend.
- Holidays: returns an array of serial date numbers that represent holidays between two dates.
- HolidayName: return the holiday name that falls on the given date.
- FindHoliday: returns the date for a given holiday in a particular year.
Date series functions
- DAILY_SERIES: array of dates that represent work days between two dates.
- WEEKLY_SERIES: array of dates that represent first/last work day for each week between two dates
- BIWEEKLY_SERIES: array of dates that represent first/last work day for each bi-weekly periods between two dates.
- MONTHLY_SERIES: array of dates that represent first/last work day for each month between two dates.
|
