What is the function to tell me the current Month

[shadestreet]

I assumed it was =MONTH()

But sadly it is not.

Help

 

[Peo Sjoblom]

=TODAY()

format as mmmm

Or in one fell swoop

=TEXT(TODAY(),"mmmm")

 

[Dave Peterson]

One more swoop:

=month(today())

will return a number.

 

[shadestreet]

Thanks, I tried using a similar approach, but there is no "mmmm" forma
when I tried to format the style of cell. The closest I could find wa
March-98 style.

Good tip, thank

 

[CLR]

=TEXT(NOW(),"mmmm")
or
=MONTH(NOW())


Vaya con Dios,
Chuck, CABGx3

 

[JE McGimpsey]

You can enter

mmmm

in the textbox after selecting "Custom" in the Format/Cells/Number
dialog.