Excel: How to use the DATEDIF function | lynda.com tutorial


This Excel tutorial shows how to calculate the time between dates by year, month, and day using the DATEDIF function. Watch more at

This specific tutorial is just a single movie from chapter four of the Excel 2007: Working with Dates and Times course presented by lynda.com author Dennis Taylor. The complete Excel 2007: Working with Dates and Times course has a total duration of 1 hour and 27 minutes and explains what’s going on behind the scenes when Excel stores dates and times, gives tips for entering dates and times, and shows options for date and time formatting

Excel 2007: Working with Dates and Times table of contents:

1. Excel’s Date/Time System
2. Creating Date/Time Entries
3. Date/Time Formatting
4. Date/Time Functions
5. Calculating with Dates and Times
6. Using Dates and Times with Excel Commands

Nguồn: trumbatdongsan.vn

Xem thêm bài viết khác: trumbatdongsan.vn/tong-hop


  1. The excel lynda vids are brilliant. The author gives very clear concise information and makes it easier for a excel newbie like me to reproduce the excel functions.

  2. If your using the formula to add up the years worked in a company with the Today function would it atomatically roll from 7 yrs to 8yrs by your computer clock


Please enter your comment!
Please enter your name here