Use a custom format and format the cells to "mmmm". If you want that month
returned in a different column, say into column B, then set column B to
custom format ("mmmm"), then =A1 in column B.

"Nige Danton" wrote:

I have a column of dates (mm/dd/yyyy) and want to return the month
e.g. 04/15/2007 and want a function that returns April. How do I do
that? Many thanks.

--
Nige Danton