Counting forward periods with EOMONTH()
In this exercise, you will use the EOMONTH() function to calculate the end of the month for a series of dates.
In some cases, the start date will be provided, and in other cases, the months offset will be provided.
Remember that the EOMONTH() function returns the last day of the month from the date specified, offset by the number of months specified.
Diese Übung ist Teil des Kurses
Loan Amortization in Google Sheets
Anleitung zur Übung
- Enter the correct values or
EOMONTH()formula to make the values calculated using theEOMONTH()formula in columnCequal the dates in columnD. - In cases where a date is required, always enter the last day of the month.
- Do not use absolute references on the
EOMONTH()formulas.
Interaktive Übung
Setze die Theorie in einer unserer interaktiven Übungen in die Praxis um
Übung starten