i want to display the month from a date into another cell

W

weazal5

i have to know how to display the month in "mmmm" form from another date in a
new cell. So if the date is "23/4/05", i have to display "April"
 
N

Niek Otten

=A1 and format Custom as "mmmm"
or
=TEXT(A1,"mmmm")

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top