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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - i want to display the month from a date into another cell (https://www.excelbanter.com/excel-worksheet-functions/23610-i-want-display-month-date-into-another-cell.html)

weazal5

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

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"

Niek Otten

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"weazal5" wrote in message
...
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"

All times are GMT +1. The time now is 03:04 AM.