Exercises / Dates and deadlines · 10 of 10
Turn dates into month names
TEXT(date, format) writes a date as text: "mmmm" is the month name (March), "mmm" the short name (Mar), "dddd" the weekday (Monday), "yyyy" the year.
Your taskIn C2, use TEXT to return the full month name of the date in A2, like "March". It will be copied down to C7.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C |
|---|---|---|---|
| 1 | Date | Amount | Month |
| 2 | 14 Jan 2026 | $420.00 | |
| 3 | 3 Mar 2026 | $310.00 | |
| 4 | 28 Mar 2026 | $515.00 | |
| 5 | 9 Jun 2026 | $280.00 | |
| 6 | 17 Sep 2026 | $640.00 | |
| 7 | 30 Nov 2026 | $390.00 |