Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Building a date from text pieces. DATE(year, month, day) builds a real date from three numbers, and LEFT, MID and RIGHT can cut those numbers out of a text date. You have to know the order in the source. Excel doesn’t complain about a month above 12: it rolls into the next year.
=DATE(RIGHT(C2,4),MID(C2,4,2),LEFT(C2,2)) reads 25/03/2025 as 25 Mar 2025
Part of the CRM import wrote signup dates as text in the US style month/day/year, like 12/14/2024. You asked the AI assistant to turn them into real dates for the cohort report.
AI assistant: “Done! B2:B9 converts each signup text into a real date with DATE, LEFT, MID and RIGHT.”
Check the AI’s formulas in B2:B9 against the text in column A. Fix them so each row is the real date the text means (month first, then day, then year).
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Signup (text) | Signup date | Contact | |||||
| 2 | 12/14/2024 | 2025-02-12AI | Kevin Hart | |||||
| 3 | 10/14/2023 | 2024-02-10AI | Chris Patel | |||||
| 4 | 10/29/2024 | 2026-05-10AI | Emma Jensen | |||||
| 5 | 05/18/2025 | 2026-06-05AI | Mark Patel | |||||
| 6 | 07/03/2023 | 2023-03-07AI | Grace Ward | |||||
| 7 | 01/04/2025 | 2025-04-01AI | Olivia Jensen | |||||
| 8 | 06/30/2024 | 2026-06-06AI | Chris Kim | |||||
| 9 | 02/17/2024 | 2025-05-02AI | Olivia Smith | |||||
| 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