Microsoft Office Tutorials and References
In Depth Information
Calculating Time between Two Dates with the DATEDIF Function
5. Click a cell where you want another date.
This date must be the same or greater than the first date from Step 3, or
you get an error.
6. Enter a comma ( ,).
7. Enter an interval.
See Table 12-2 for the list of intervals that you can use with the function.
Make sure that the interval is enclosed in double quotes.
8. Type a ), and press Enter.