How can I get the name of the current month in Excel???

-----Original Message-----
How can I get the name of the current month in Excel???

.

Use the function: =MONTH(TODAY())

Hi,

It would be nice if you would use a more descriptive
subject title next time.

=MONTH(TODAY())

Gives the number of the current month.

Or:

=TODAY()

formatted with this custom format: mmmm
Will show "October" in the cell.

Regards,

Jan Karel Pieterse
Excel TA/MVP

-----Original Message-----
How can I get the name of the current month in Excel???

.

In VBA

? format(date,"mmm")
Oct
? format(date,"mmmm")
October


--
Regards,
Tom Ogilvy



"Sumitha" wrote in message
...
How can I get the name of the current month in Excel???