What is the function to tell me the current Month

  • Thread starter Thread starter shadestreet
  • Start date Start date
=TODAY()

format as mmmm

Or in one fell swoop

=TEXT(TODAY(),"mmmm")
 
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
 
You can enter

mmmm

in the textbox after selecting "Custom" in the Format/Cells/Number
dialog.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Counting Months to get an Average 3
SCAN.CO - £5,300 Gone. No PC. No Answers. One of the Worst Companies Ive Ever Dealt With. 3
Excel Monthly Spread sheet. 12
Function to establish mortgage bond size. 2
Excel Message box with days of month & date. 1
Calculate the first monday of a month in the future or in the past 3
Count of remaining months 8

Back
Top