Microsoft Excel workbooks are seldom found without several cells filled with relevant dates or timestamps. As such, it is important to know how to deal with them, and in this course, Excel 2016 Time and Date Function Playbook, that’s exactly what you’ll be doing. To effectively compartmentalize all these functions, the course is divided into 5 modules. In the first module, you’ll learn how to reference time and date in excel using the NOW and TODAY functions. Then, you’ll look at comparing date and time in a cell with the current date and time using the NOW and TODAY functions. Next, you’ll learn to serialize dates and times before moving on to use several functions such as TIMEVALUE, DATEDIF, and DAYS360, to find the difference between dates and times. Finally, you’ll explore how to parse dates and times in Excel with further useful functions.
Author Name: Pratheerth Padman
Author Description:
Pratheerth is a Data Scientist who has entered the field after an eclectic mix of educational and work experiences. He has a Bachelor’s in Engineering in Mechatronics from India, Masters in Engineering Management from Australia and then a couple of years of work experience as a Production Engineer in the Middle East. Then when the A.I bug bit him, he dropped everything to dedicate his life to the field. He is currently working on mentoring, course creation and freelancing as a Data Scientist.

Table of Contents

• Course Overview
  1min
• Referencing Current Date and Time
  7mins
• Serializing Dates and Times in Excel
  8mins
• Calculating Differences Between Dates and Times
  19mins
• Finding the Day, Month, Weekday, or Year of a Date
  8mins
• Finding the Hour, Minute, or Second of a Time
  7mins