How to add a onth to the table

[Sonyat810]

I have a table with the days but it doesn;t show the month. How can I create a column that shows the Month & day?

[Idrissshatila]

hello @Sonyat810 , 

can you show me what type of date you have ?

if you have something like 1/1/2023 for example, to have the month in a seperate column

calculated column = format ('Tablename' [datecolumn], "mmmm")

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[Sonyat810]

This all I have as far as day, but no month. It won't let me change it to date format, so I will have to create something.

[Idrissshatila]

Hello @Sonyat810 ,

but how would you know this day falls under which month ? this won't work like that.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[Sonyat810]

I want this to say "August". How do I write that? This is what I have:

Month = IFERROR ( VALUE ( 'CE Lookup 2'[Day] ), BLANK ( ) )

[Ahmedx · Accepted solution]

pls try this

Month = IFERROR (FORMAT( DATE(2023,8, VALUE ( 'CE Lookup 2'[Day] )),"MMMM"), BLANK ( ) )

[Sonyat810]

All of the days are for August.