Date & time › EOMONTH28 / 67

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

A baking supply distributor in Pontianak gives its bakery customers payment terms of "end of next month". The admin wants the due date filled in automatically from the invoice date.

Task

In D2:D7, calculate the due date, the last day of the month after the invoice date, using EOMONTH, written in D2 and copied down to D7. Column D is already formatted as a date.

Cells to fillD2:D7

Required functionsEOMONTH

Expected result

Loading the expected result…

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

Hint 1
EOMONTH(date, months) returns the last day of the month shifted by months. A 0 means the end of the same month.
Hint 2
The end of next month means shifting by 1 month: =EOMONTH(B2, …).

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

D2:D7

=EOMONTH(B2,1)

Write it in D2, then fill down to D7.

Explanation

=EOMONTH(B2,1) turns invoice date 14/01/2025 into 28/02/2025, and 10/01/2024 into 29/02/2024 because of the leap year, so you never need to remember how many days each month has. December invoices are automatically due in January of the next year. In Google Sheets, the result of EOMONTH sometimes shows as a serial number (for example 45716); fix it with Format > Number > Date. Variation: EOMONTH(B2,0)+1 gives the 1st of the next month.

Starting worksheet: Sheet1
Row	A	B	C	D
1	Invoice no.	Invoice date	Bakery	Due date
2	F-2401	10/01/2024	Roti Kenari
3	F-2501	14/01/2025	Bakery Khatulistiwa
4	F-2502	31/01/2025	Roti Kenari
5	F-2503	03/02/2025	Kue Bu Darmi
6	F-2504	20/11/2025	Bakery Khatulistiwa
7	F-2505	15/12/2025	Roti Mentari
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result