How Do I Extract Month Name From a Date?

I want to extract Month from a Date … let me explain a bit more
I have a column Date, Sex, Value ……. and I have another column Month, Male, Female, Total Value …so I want to calculate total MALE, FEMALE, TOTAL for the month.
but when I am using any function like Date, Monthname etc..all return digit like 1,2,3.. but nothing is returning Months like January, February etc…
—–
Kailash Purohit