Microsoft Excel 2021365 - Beginner to Advanced - Calculate Dates with EDATE and EOMONTH

The video tutorial explains the EO Month and E Date functions in Excel. EO Month is used to find the last day of a month, which is useful for calculating loan payment dates. The tutorial demonstrates how to use EO Month to fill in payment dates in a loan amortization schedule. It also covers a trick to quickly fill numbers in a spreadsheet. The E Date function is introduced to calculate dates a specific number of months before or after a given date, with examples of formatting cells to display dates correctly.

What does the EO Month function primarily calculate?

• The start of the year

• The middle of the month

• The end of the month

• The first day of the month

Which method can be used to quickly fill a series of numbers in a spreadsheet?

• Typing each number manually

• Using the fill handle and series option

• Copy-pasting the first number

• Using a calculator

What is the purpose of locking a cell reference when using the EO Month function?

• To prevent the cell from being edited

• To ensure the reference does not change when dragging the formula

• To make the cell bold

• To highlight the cell

How does the EO Month function handle leap years?

• It automatically accounts for the 29th day in leap years

• It always assumes February has 28 days

• It requires manual adjustment for leap years

• It ignores leap years

What does the E Date function return?

• A date a specified number of years before or after

• A date a specified number of weeks before or after

• A date a specified number of months before or after

• A date a specified number of days before or after

How can you format cells to display dates correctly when using the E Date function?

• Change the cell format to percentage

• Change the cell format to text

• Change the cell format to currency

• Change the cell format to short date

If you want to calculate a date three months before a given date using E Date, what should you input?

• E Date(start date, 3)

• E Date(start date, -3)

• E Date(start date, 0)

• E Date(start date, 1)