Get the month from yyyy-mm format?

%3CLINGO-SUB%20id%3D%22lingo-sub-2865151%22%20slang%3D%22en-US%22%3EGet%20the%20month%20from%20yyyy-mm%20format%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2865151%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20dates%20in%20the%20yyyy-mm%20format%20and%20I%20am%20trying%20to%20create%20a%20new%20column%20with%20just%20the%20month.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2865151%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2865171%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20the%20month%20from%20yyyy-mm%20format%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2865171%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1190864%22%20target%3D%22_blank%22%3E%40erict655%3C%2FA%3E%26nbsp%3BCustom%20format%20the%20new%20column%20as%20%3CSTRONG%3Emmmm%3C%2FSTRONG%3E%20to%20display%20the%20full%20month%20name%2C%20like%20%3CEM%3EOctober%3C%2FEM%3E%2C%20or%20use%20%3CSTRONG%3Emmm%3C%2FSTRONG%3E%20to%20display%20%3CEM%3EOct.%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have dates in the yyyy-mm format and I am trying to create a new column with just the month.

1 Reply

@erict655 Custom format the new column as mmmm to display the full month name, like October, or use mmm to display Oct.