Microsoft Excel Tutorial: How to Enter and Format Dates in Excel

This video tutorial covers how to enter and format dates in Excel. It explains the standard numeric format for dates and demonstrates how to customize date formats using slashes and other separators. The tutorial also covers using Excel formulas to extract specific components of a date, such as the day, month, or year. Viewers are encouraged to practice these techniques and reach out with any questions.

What are the parameters used in Excel to represent day, month, and year in date formatting?

• Y for day, M for month, D for year

• D for day, Y for month, M for year

• D for day, M for month, Y for year

• M for day, D for month, Y for year

How can you customize a date format in Excel to include slashes?

• By using the 'Custom' format option

• By selecting the 'General' format

• By choosing the 'Text' format

• By applying the 'Currency' format

Which format option would you use to display only the month and year in Excel?

• Date Month

• Month Year

• Day Month

• Year Month

What formula would you use to get today's date in Excel?

• =TODAY()

• =DATE()

• =CURRENT()

• =NOW()

If you want to extract only the year from a date in Excel, which formula should you use?

• =YEAR()

• =MONTH()

• =DATE()

• =DAY()