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 (
,).