Compute a loan's exact tenure in complete months
Column A holds an RHB Bank loan's disbursement date, column B its maturity date. Write formulas in C1:C3, one per row, that return the tenure in complete months — a partial month at the end should NOT round up.
Starting grid
| A | B | C | |
|---|---|---|---|
| 1 | 2024-03-15 | 2026-09-15 | |
| 2 | 2025-01-10 | 2025-07-05 | |
| 3 | 2023-11-01 | 2026-11-01 |
Basic
The expected output and walkthrough for this question unlock with a Basic plan.
Basic
The reference formulas and walkthrough for this question unlock with a Basic plan.
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime