ExcelBanter - Formula/Function to insert month by name in a cell

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

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

- - Formula/Function to insert month by name in a cell (https://www.excelbanter.com/excel-worksheet-functions/111663-formula-function-insert-month-name-cell.html)

mjdntn

Formula/Function to insert month by name in a cell

Hi, I would like to write a formula that would automatically write the
current month, by name, in a cell. thanks in advance. Mike

Marcelo

Formula/Function to insert month by name in a cell

hi

=today() custom format as "mmmm" (no quotes)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo

"mjdntn" escreveu:

Hi, I would like to write a formula that would automatically write the
current month, by name, in a cell. thanks in advance. Mike

RagDyeR

Formula/Function to insert month by name in a cell

One way:

=TEXT(TODAY(),"mmmm")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mjdntn" wrote in message
oups.com...
Hi, I would like to write a formula that would automatically write the
current month, by name, in a cell. thanks in advance. Mike

All times are GMT +1. The time now is 12:43 PM.