Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
DATEVALUE. DATEVALUE(date_text) turns a date written as text into a real date (a serial number), so you can sort, subtract and count it. Text dates are left-aligned and don’t react to date formulas; real dates do. VALUE works on the same text too.
=DATEVALUE("2025-03-15") gives 15 Mar 2025 as a real dateIn the CRM import, signup dates such as 2025-01-20 arrived as text. They look like dates but can’t be counted or compared, and marketing wants to know how many of these contacts signed up in 2025.
In B2:B9, turn each text date in column A into a real date. In E2, count how many of those dates fall in 2025 or later.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Signup (text) | Signup date | ||||||
| 2 | 2025-01-20 | Signed up in 2025 | ||||||
| 3 | 2024-04-21 | |||||||
| 4 | 2023-04-13 | |||||||
| 5 | 2023-01-29 | |||||||
| 6 | 2025-03-26 | |||||||
| 7 | 2025-02-05 | |||||||
| 8 | 2025-02-02 | |||||||
| 9 | 2024-07-01 | |||||||
| 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