Context English Xhosa
ANALYSIS_Workday The start date
ANALYSIS_Workday Holidays
ANALYSIS_Yearfrac Returns the number of years (including fractional part) between two dates
ANALYSIS_Yearfrac The start date
ANALYSIS_Yearfrac End date
ANALYSIS_Yearfrac The end date
ANALYSIS_Yearfrac Basis
ANALYSIS_Yearfrac Basis indicates the day-count convention to use in the calculation
ANALYSIS_Edate The start date
ANALYSIS_Weeknum Returns the number of the calendar week in which the specified date occurs.
This function exists for interoperability with older Microsoft Excel documents, for new documents use WEEKNUM instead.
ANALYSIS_Weeknum The date or date serial number
ANALYSIS_Weeknum Indicates the first day of the week (1 = Sunday, 2 = Monday)
ANALYSIS_Eomonth The start date
ANALYSIS_Networkdays Returns the number of workdays between two dates.
This function exists for interoperability with older Microsoft Excel documents, for new documents use NETWORKDAYS instead.
ANALYSIS_Networkdays The start date
ANALYSIS_Networkdays End date
ANALYSIS_Networkdays The end date
ANALYSIS_Networkdays Holidays
ANALYSIS_Iseven The number
ANALYSIS_Isodd The number