Month labels with TEXT
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Turn each date into a month label as text, with the three-letter month and the four-digit year, such as Jan 2026. Fill B2 and B3.
What this exercise teaches
TEXT turns a date or number into text in the format you spell out: mmm gives Jan, mmmm gives January, ddd gives Thu. The result is text, so use it for labels and keep the real date for calculations.
A hint if you get stuck
TEXT(value, format) returns text. In the format, mmm is the short month name and yyyy the full year.
Try it now, free, no account needed
Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.
Open this exerciseMore exercises in Text and dates
- Build an email address
- Pull out the domain
- Payment due dates
- Clean up names
- Join the tags
- Digits only
- Days between dates
- Year and month
- Contract end date
- Pay by month end
- Split last name, first name
- Calendar quarter
- IDs with leading zeros
- Mask an account number
- File extension
- Completed years of service
- Working days on a task
- Ship-by dates
- Weekend or weekday
- Days in the month