Date & time › EOMONTH65 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeEOMONTH

EOMONTH: due at the end of next month

The finance team of a bakery in Tasikmalaya records invoices from its flour supplier. The supplier gives payment terms until the end of the following month: an invoice dated January 15 is due on February 28, and one dated March 31 is due on April 30.

Task

Fill C2:C4 with the due date: the last day of the month after the invoice date (column B).

Cells to fillC2:C4

Required functionsEOMONTH

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
EOMONTH(date, n) returns the last day of the month that is n months from that date.
Hint 2
The following month means n = 1. Write the formula in C2 and copy it down.
Hint 3
Pattern: =EOMONTH(…, 1) with the invoice date on the same row.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

C2:C4

=EOMONTH(B2,1)

Write it in C2, then fill down to C4.

Explanation

=EOMONTH(B2,1) automatically handles months of different lengths and leap years, which is hard to get right by adding 30 days by hand. With n = 0 you get the end of the same month, and EOMONTH(B2,0)+1 gives the 1st of the next month. The result is a date serial number, so the cell needs a date format (already set to dd/mm/yyyy here).

Starting worksheet: Sheet1
Row	A	B	C
1	Invoice	Invoice date	Due date
2	INV-2601	15/01/2026
3	INV-2602	31/03/2026
4	INV-2603	05/12/2026
5
6
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result