Hi ,
There are two ways to do this , one by using a data conversion formula , another by using a simpler formula , but changing the cell format.
Using a formula such as :
=TEXT(date , "mmmm")
will display the text string March in the cell which contains this formula.
Using a formula in B1 such as :
=A1
where A1 contains the date , and then formatting this cell B1 to mmmm will display March in B1 , even though B1 will contain a number 42814 ,which is equivalent to the date 20 March 2017.
Narayan