Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 5/6

EOMONTH: end of the month

Exercise 1 of 3

In B2, find the last day of the month the date is in.

About this lesson

EOMONTH returns the last day of a month, some months before or after a date. Handy for due dates.

In this lesson

  1. In B2, find the last day of the month the date is in.
  2. In B2, find the last day of the following month.
  3. In B2, find the first day of the date's month.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in B2 and press Enter to check.