Work with dates
Show the month name
=TEXT(A2,"mmmm")How it works in Excel
- A2 is the date.
- "mmmm" means the full month name.
- Use "mmm" for the short form, such as Mar.
- The result is text.
The idea in general
It reads the month off the calendar and writes it out.
What I assumed
- The date is in A2.
Check the result on your own data before relying on it.