The Complete Excel Guide: Beginners to Advanced - Basic Date and Time Functions

This video tutorial covers essential date and time functions in Excel 2019, including TODAY, NOW, and DATEVALUE. It explains how to use these functions to manage dynamic and static dates, convert text dates, and extract date components like year, month, and day. The tutorial also demonstrates building dates from individual components using the DATE function.

Which function in Excel 2019 can be used to automatically populate the current date in a cell?

• =DATE()

• =NOW()

• =TODAY()

• =TIME()

What is the keyboard shortcut to input a static date in Excel?

• Ctrl + Shift + ;

• Alt + D

• Ctrl + ;

• Shift + D

Which function provides both the current date and time in Excel?

• =TODAY()

• =NOW()

• =TIME()

• =DATE()

How can you convert a text date into a regular date format in Excel?

• Using the TEXT function

• Using the DATEVALUE function

• Using the VALUE function

• Using the DATE function

Which function would you use to extract the year from a date in Excel?

• =YEAR()

• =MONTH()

• =DAY()

• =DATE()

What is the purpose of the DATE function in Excel?

• To convert text to date

• To build a date from year, month, and day

• To format a date

• To display the current date

How can you add 30 days to a date in Excel?

• Use =DATE()+30

• Use =TODAY()+30

• Use =NOW()+30

• Use =DATEVALUE()+30