Microsoft Office Tutorials and References
In Depth Information
Syntax
Figure 11.45.
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.
Syntax
=DAYS(end_date, start_date,)
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-
ments:
Search JabSto ::




Custom Search