The functions whose names end with _ADD return the same results as the corresponding Microsoft Excel functions. Use the functions without _ADD to obtain results based on international standards. For example, the WEEKNUM function calculates the week number of a given date based on international standard ISO 6801, while WEEKNUM_ADD returns the same week number as Microsoft Excel.
这些名称以 _ADD 结尾的函数会返回与对应的 Microsoft Excel 函数相同的结果。使用不带 _ADD 的函数可得到基于国际标准的结果。例如，WEEKNUM 函数基于国际标准 ISO 6801 对指定日期计算星期编号，而 WEEKNUM_ADD 会返回与 Microsoft Excel 中相同的星期编号。