Microsoft Office Tutorials and References
In Depth Information
Calculating Time between Two Dates with the DATEDIF Function
Table 2-12 (continued)
Value
What It Means
Comment
“yd”
Days
excluding years
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.
“ym”
Months
excluding
years
The count of complete months between the dates,
but as if the two dates are in the same year. The
year is ignored.
“md”
Days
excluding months
and years
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.
Figure 12-10:
Counting
days,
months, and
years with
DATEDIF.
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 ( ,).
Search JabSto ::




Custom Search