Formuladrill

Level 4: Text and dates Exercise 68 of 118

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.

Functions used: TEXT

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 exercise

More exercises in Text and dates