Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
EOMONTH. EOMONTH(date, months) returns the last day of the month that is months away from date. 0 is the end of the same month, 1 the end of next month and -1 the end of last month. It handles 28, 30 and 31-day months for you.
=EOMONTH(C2,0) gives 31 Mar 2025 for a refund on 19 Mar 2025
Brightline’s invoices are due on the last day of the month after the order, so an order on 4 March is due on 30 April. Finance wants the due date and the days of credit for each sample order.
In C2:C9, return the due date: the last day of the month after the order date in column B. In D2:D9, return the number of days from the order date to the due date.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Order date | Due date | Days of credit | ||||
| 2 | 50001 | 2025-01-01 | ||||||
| 3 | 50094 | 2025-02-01 | ||||||
| 4 | 50186 | 2025-03-04 | ||||||
| 5 | 50279 | 2025-04-03 | ||||||
| 6 | 50372 | 2025-05-02 | ||||||
| 7 | 50654 | 2025-08-06 | ||||||
| 8 | 50945 | 2025-11-11 | ||||||
| 9 | 51042 | 2025-12-12 | ||||||
| 10 | ||||||||
| 11 | ||||||||
| 12 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe