With date in A1

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

If this post helps click Yes
---------------
Jacob Skaria


"Eán" wrote:

Hi
I have a coloum of dates dd/mm/yyyy but would like in a separate coloum to
show only the month - how would I write a formula to return "April" for all
dates with 04 in the mm?
Please & thank you.