Context English Bavarian
ANALYSIS_Weeknum Date
ANALYSIS_Weeknum The date or date serial number
ANALYSIS_Weeknum Return type
ANALYSIS_Weeknum Indicates the first day of the week (1 = Sunday, 2 = Monday)
ANALYSIS_Eomonth Returns the serial number of the last day of the month that comes a certain number of months before or after the start date
ANALYSIS_Eomonth Start date
ANALYSIS_Eomonth The start date
ANALYSIS_Eomonth Months
ANALYSIS_Eomonth Number of months before or after 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 Start date
ANALYSIS_Networkdays The start date
ANALYSIS_Networkdays End date
ANALYSIS_Networkdays The end date
ANALYSIS_Networkdays Holidays
ANALYSIS_Networkdays List of date values representing days off (vacation, holidays, etc.)
ANALYSIS_Iseven Returns the value 'true' if the number is even
ANALYSIS_Iseven Number
ANALYSIS_Iseven The number
ANALYSIS_Isodd Returns the value 'true' if the number is odd