Dates may be entered as text strings within quotation marks (for example, '0'), as serial numbers (for example, 36921, which represents January 30, 2001, if you're using the 1900 date system), or as the results of other formulas or functions (for example, DATEVALUE('0')).Ī date that represents the last, or ending, date of the period. SyntaxĪ date that represents the first, or starting date of a given period. Please see the known issues section of this article for further details. The DATEDIF function may calculate incorrect results under certain scenarios. Warning: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3.
