Microsoft Office Tutorials and References
In Depth Information
Figure 11.45. In rare cases,
In rare cases, DATEDIF
DATEDIF will report 1 month and – 2 days.
will report 1 month and – 2 days.
Despite this problem, for 363 days a year, DATEDIF remains an ef-
fective way to express a date delta as a certain number of years,
months, and days.
The DAYS function always calculates elapsed days between two dates. In-
troduced in Excel 2013, the function offers one new trick: It will work with
text dates as well as real dates. This function takes the following argu-