Display Month

[Christine Wilso]

How do I format excel to just show the current month. I know that
TODAY() shows todays date dd/mm/yy, so how do I pick out just the
month? I would also like it to display the actual month such as
September rather than 09.

 

[Jazzer]

Hi,

The number of current month, you can get by:

=MONTH(TODAY())

and the name of the current month by:

=TEXT(TODAY(),"mmm")

(I'm not actually sure if the "mmm" part is correct with englis
regional settings, because the date formattings are local)

- Asse

 

[Ron Rosenfeld]

How do I format excel to just show the current month. I know that
TODAY() shows todays date dd/mm/yy, so how do I pick out just the
month? I would also like it to display the actual month such as
September rather than 09.

Format/Cells/Number/Custom Type: mmmm

will display only the month, all spelled out.


--ron