Context English Xhosa
ANALYSIS_Workday Returns the serial number of the date before or after a specified number of workdays Kubuyiselwa inombolo yentengiso yomhla phambi okanye emva kwenani elixeliweyo leentsuku zomsebenzi
ANALYSIS_Workday Start date Qalisa apha
ANALYSIS_Workday The start date
ANALYSIS_Workday Days Iintsuku
ANALYSIS_Workday The number of workdays before or after the start date Inani leentsuku zokusebenza phambi okanye emva komhla wokuqalisa
ANALYSIS_Workday Holidays
ANALYSIS_Workday List of date values of days off (vacation, holidays, etc.) Uludwe lwamaxabiso emihla yeentsuku zokungasebenzi (ikhefu, iiholideyi, njl.njl.)
ANALYSIS_Yearfrac Returns the number of years (including fractional part) between two dates
ANALYSIS_Yearfrac Start date Qalisa apha
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 Returns the serial number of the date that is a specified number of months before or after the start date Kubuyiselwa inani lentengiso lomhla elilinani elixeliweyo leenyanga phambi okanye emva komhla wokuqalisa
ANALYSIS_Edate Start date Qalisa apha
ANALYSIS_Edate The start date
ANALYSIS_Edate Months Iinyanga
ANALYSIS_Edate Number of months before or after the start date Inani leentsuku zokusebenza phambi okanye emva komhla wokuqalisa
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.