The basic work of text function here is to convert a date into a month by using a specific format =TEXT(,"MMM") By default, you have 5 different date formats which you can use in the text function These formats will return month name as a text All you need to do, refer a date in the function and specify a format