Display Month

C

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.
 
J

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
 
R

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.
Click to expand...

Format/Cells/Number/Custom Type: mmmm

will display only the month, all spelled out.


--ron
 
Top