Tag: extract month in excel

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.