Month Name

mrshl9898

Well-known Member
Joined
Feb 6, 2012
Messages
1,951
Hi,

I'm using the following

Month = FORMAT(MONTH(Sheet1[Date]),"MMMM")

To get the month name, however, all Jan dates are showing as December, the rest are showing January.

Any ideas what could be wrong? Sheet1[Date] is a date data type.



*All good, worked it out.
 
Last edited:

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Didn't notice the last remark.
 
Last edited:
Upvote 0
= FORMAT(MONTH(Sheet1[Date]),"MMMM")

maybe:
Code:
[SIZE=1]=FORMAT(MONTH([B][COLOR="#FF0000"]Table1[/COLOR][/B][Date]),"MMMM")[/SIZE]

edit:
but if your table has name: Sheet1 so I don't know what is wrong
 
Last edited:
Upvote 0
It was =FORMAT(Sheet1[Date],"MMMM") in the end.

Looks like FORMAT(number,"MMMM") works on days of the year by default

1 = DEC
2 = JAN
33 = FEB
 
Last edited:
Upvote 0
I assume we are talking about the same thing - DAX
could you tell me what is your table name (table with Date column)?

dax-monthnamefromdate.jpg
 
Upvote 0
I assume we are talking about the same thing - DAX
could you tell me what is your table name (table with Date column)?

This is not the case - OP made a mistake using numbers for month 1..12 and then used Format to get month name which is wrong, as excel needs full date to get month name in the right way. If you want to resolve it in this case you need to change source column to full date or use formula like date() with hardcoded year and day like FORMAT(date(2018, Sheet1[Date], 1), "MMMM") - i'm assuming heare this date column was in fact month stored as number.

BTW @mrshl9898 - please read this on how excel is storing date http://www.cpearson.com/excel/datetime.htm
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,172
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top