Microsoft Office Tutorials and References
In Depth Information
Calculating Time between Two Dates with the DATEDIF Function
Table 2-12 (continued)
What It Means
The count of inclusive days from the start date
through the end date, but as if the two dates are in
the same year. The year is ignored.
The count of complete months between the dates,
but as if the two dates are in the same year. The
year is ignored.
The count of inclusive days from the start date through
the end date, but as if the two dates are in the same
month and year. The month and year are ignored.
Figure 12-10 shows some examples of using DATEDIF. Column A has start
dates. Column B has end dates. Columns C through H contain formulas with
DATEDIF. The DATEDIF function uses the start and end dates on each given
row, and the interval is labeled at the top of each column, C through H.
Here’s how to use DATEDIF:
1. Select the cell where you want the results to appear.
2. Enter =DATEDIF( to begin the function entry.
3. Click a cell where you have a date, or enter its address.
4. Enter a comma ( ,).