Display the current month in Excel 2010

JustineK Posted messages 8 Status Member -  
JustineK Posted messages 8 Status Member -
Hello,

I would like to have a cell in my table that displays the current month in the format mmmm-aa rather than a number.
For example: if I enter the formula =MONTH(TODAY()) in my file, the result is 2, while I would like it to display Feb. 2013. If I choose the date format it doesn't work either. I will then have formulas that refer to this cell (e.g., only consider data from the current month in a formula).
I'm not sure if I'm clear enough.
Could you please help me?

Thank you in advance!

Configuration: Windows 7 / Chrome 24.0.1312.57

3 answers

  1. pilas31 Posted messages 1878 Status Contributor 648
     
    Hello,

    To display the month clearly, just leave =TODAY() in the cell and in the format choose a custom format with mmmm

    For formulas, it depends on the type of formula desired.

    Best regards,
    14
    1. pilas31 Posted messages 1878 Status Contributor 648
       
      Yes, Vaucluse is right (of course!) I didn't read it carefully
      format mmmm.aaaa
      or mmm.aaaa if we want the short month names
      0