始める無料で始める

Counting same month and backward with EOMONTH()

In the last exercise, you used the EOMONTH() function to determine the last day of a month going forward. In this exercise, you will use the EOMONTH() function to determine the last day of the current month, as well as prior months.

While you might not use EOMONTH() going backward on most amortization schedules, using EOMONTH() to get the last day of the current month is very useful!

この演習はコースの一部です

Google Sheetsで学ぶローン返済(アモチゼーション)

コースを見る

演習の手順

  • Enter the correct values or EOMONTH() formula to make the values calculated using the EOMONTH() formula in column C equal the dates in column D.
  • In cases where a date is required, always enter the last day of the month. Remember that February has 29 days in 2020!
  • Do not use absolute referencing on your EOMONTH() functions.

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する