=IF(G2="","",MONTH(G2)) - How can this show written month (January not 1)

[Daniellel]

Hi,

Thank you in advance for any help you can give.

I have a column of dates in Column G and the formula in title and below in column AE. I want it so show the written value not a number...

=IF(G2="","",MONTH(G2)) - How can this show written month (January not 1)

Thanks again
Danielle

 

[VoG]

Try

=IF(G2="","",TEXT(G2,"mmmm"))

 

[Daniellel]

Perfect, Thank you very much!