Excel

[Sumitha]

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

 

[Gregers Bjerre]

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

.

Use the function: =MONTH(TODAY())

 

[Jan Karel Pieterse]

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

 

[Tom Ogilvy]

In VBA

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