Forum Discussion
Solved
What's wrong with excel data model Month function malfunctioning
is this a known issue?
That could mean you have texts which looks like date, not dates (aka numbers). Please check in Format, is it
or
Shouldn't the formula refer to the date column (Week of:) instead of the column with month number?
that was my first formula =MONTH([COLUMN1])