View original (French)

Display the current month in Excel 2010

JustineK Posted messages 8 Status Membre -  
JustineK Posted messages 8 Status Membre -
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 réponses

Réponse 1 / 3
pilas31 Posted messages 1878 Status Contributeur 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
pilas31 Posted messages 1878 Status Contributeur 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