Therefore, dates entered in this format are not always recognised as dates and result in erroneous calculations. To keep dates from being interpreted as parts of formulae, place them in quotation marks, for example, &quot; 20/07/54 &quot; .
在输入日期时，作为日期分隔符的连字符和斜线符号可能会被解释为运算符号。因此，按照此格式输入的日期不一定会被识别为日期，并可能会导致错误的运算。为防止日期被解释为公式的一部分，请在日期前后加上引号，例如 &quot; 07/20/54 &quot; 。