easyTraveloka · date
Find the last day of a booking's check-in month
Column A holds a Traveloka hotel check-in date. Write a formula in B1 that returns the last day of that check-in month, formatted as YYYY-MM-DD.
Starting grid
A1
| A | B | |
|---|---|---|
| 1 | 2026-03-14 |
Show expected output▾
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.
B1
| A | B | |
|---|---|---|
| 1 | 2026-03-14 |