Date & time › DATE, YEAR, MONTH72 / 144

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

MediumFreeDATEYEARMONTH

DATE: due on the 10th of next month

A savings and loan cooperative in Klaten collects a member's first installment on the 10th of the month after the loan is paid out. A loan paid out on December 23 therefore has its first installment due on January 10 of the following year.

Task

Fill C2:C6 with the first installment due date: the 10th of the month after the payout date (column B). Build the date with DATE, YEAR and MONTH.

Cells to fillC2:C6

Required functionsDATEYEARMONTH

Expected result

Loading the expected result…

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

Hint 1
DATE(year, month, day) builds a date from three numbers. Take the year and month from the payout date with YEAR and MONTH.
Hint 2
The next month = month number + 1. No need to worry about December: DATE automatically reads month 13 as January of the next year.
Hint 3
Pattern: =DATE(YEAR(B2), …, 10).

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

=DATE(YEAR(B2),MONTH(B2)+1,10)

Write it in C2, then fill down to C6.

Explanation

=DATE(YEAR(B2),MONTH(B2)+1,10) takes the year and month from the payout date, adds one month, then fixes the day at 10. For 23/12/2026 the month becomes 13, which DATE reads as January 2027. A common mistake is B2+30, which lands on a random day instead of always the 10th. Another correct approach: =EOMONTH(B2,0)+10.

Starting worksheet: Sheet1
Row	A	B	C
1	Member	Paid out on	First due date
2	Pak Bambang	05/07/2026
3	Bu Ratih	31/08/2026
4	Teguh	10/10/2026
5	Sinta	19/11/2026
6	Mas Andi	23/12/2026
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result