The Complete Excel Guide: Beginners to Advanced - How Date and Time Works

This video tutorial covers the use of date and time functions in Excel 2019. It explains the importance of setting correct date and time formats on your device and how to customize these settings in Excel. The tutorial provides practical examples of working with dates and times, including how Excel stores these as numbers and fractions of a day. It also highlights the importance of understanding formatting codes and introduces various functions for manipulating dates and times.

What is the significance of the cutoff year in Excel date settings?

Describe how to format a cell to display a date and time together in Excel.

What should you do if Excel does not recognize a date or time combination entered as part of a sentence?

How can you find a function that calculates a date 60 days from today in Excel?