If posting date is EOM, then reflect the Month (in a new Column), otherwise reflect blanks

[bgonen7]

[v-xinruzhu-msft · Accepted solution]

Hi @bgonen7 

You can create a new column:

Column = IF([Date]=EOMONTH([Date],0),FORMAT([Date],"MMM-YY",BLANK()))

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FreemanZ]

hi @bgonen7 

try to add a column with this:

IF(       [Posting_Date]=EOMONTH([Posting_Date]),

  FORMAT([Posting_Date], "MMM-YY")

)