Date & time › EDATE66 / 144

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

EasyFreeEDATE

EDATE: next boarding house payment date

Nadia manages a boarding house (kos) in Yogyakarta. Tenants may pay in advance for 1, 3, 6 or 12 months. She wants each tenant's next payment date so she can send reminders on time.

Task

Fill D2:D6 with the next payment date: the last payment date (column B) plus the number of months already paid for (column C). Use EDATE.

Cells to fillD2:D6

Required functionsEDATE

Expected result

Loading the expected result…

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

Hint 1
EDATE(start_date, months) moves a date forward by a number of months, landing on the same day of the target month.
Hint 2
The number of months differs per tenant, so take it from column C instead of typing it into the formula.
Hint 3
Pattern: =EDATE(B2, …), then copy it down.

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:D6

=EDATE(B2,C2)

Write it in D2, then fill down to D6.

Explanation

=EDATE(B2,C2) adds months, not days. Adding C2*30 days drifts because months have different lengths. Look at Wulan: paid on 31/08/2026 for 6 months, and EDATE returns 28/02/2027 because February has no 31st. Negative months work too, for example EDATE(B2,-1) for one month earlier.

Starting worksheet: Sheet1
Row	A	B	C	D
1	Tenant	Last payment	Months paid	Next payment
2	Wulan	31/08/2026	6
3	Bagas	05/10/2026	1
4	Putri	15/07/2026	3
5	Arif	01/04/2026	12
6	Citra	30/09/2026	1
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result