To get the Month name from Date as text, you can use text function with a custom number format within excel..
Syntax:-
(1) =text(date,”mmm”) or
(2) =text(date,”mmmm”)
NOTE:
- “mmm” – to get the first 3 letters of the name of the month.
- “mmmm” – to get the full name of the month
An Examples are shown in the image below.
