Forum Discussion
Slicer Trouble
The slicers show the formatted serial date as "January" but the cell content still is 01/01/2022. And if you filter for year 2023 and don't reset the slicer for the month it will filter for 01/01/2022. And there is no match.
I would suggest a date column and for the year and month use the TEXT() function.
=TEXT(date;"YYYY") =TEXT(date;"MMMM")
Detlef_Lewin Ok. Are you saying to leave the formatting of the column as date with custom format of "mmmm" and "yyyy" respectively but the cell contents to be =TEXT(2/1/2023,"MMMM")? When I put this value in the cell, it shows up as January but obviously should be February.
That depends on your regional settings in Windows.
It is probably not dd/mm/yyyy but mm/dd/yyyy.
Detlef_Lewin I tried =TEST(1/1/2023,"mmmm") and also =TEXT(2/1/2023,"mmmm") and got the same result of "January" when expecting February. See screen-shot below.
I would strongly advise to use a cell reference and not putting the actual date in the formula.
- Could you please give me an example. I'm not fully understanding what you are saying. Right now, I have a temporary solution by using a custom format of "mmm-yy" and it seems to be working just fine. But I would like to go back to using the full month names.