Date Filter in Excel not grouping by month

[F.B]

Dear All,



I hope you are doing well

Please note that I am facing an issue with the attached sample, where I am trying to apply a filter on the only column in this excel sheet, but it is grouping the dates in the filters only if I delete them and re-enter them again.

Please assist me with this

Note: This excel was exported from a web app.

[ArviLaanemets]

You get not dates, but datestring texts. The reason is, that the date format in your windows regional settings is different from format used in web page (in web page the format is "dd/mm/yyyy" - I don't know is it US or UK format, but it is sure in your computer it must be different. E.g. for me the short date format is "dd.mm.yyyy", and I see the 1st date in column A (the date you obviously reentered) in this format. All other dates are for me strings.

I could easily convert all those strings to dates - I selected the column A, and replaced all "/" with "." (i.e. with my date delimiter).

[F.B]

Dear,

Thank you very much for your response.

However, We've tested this on a computer where short date format is dd/mm/yyyy, and although cells format was "Date", they are still not being grouped in months in the date filter.

[ArviLaanemets]

When this is case, then anyway you get texts from web. For me Replace worked, because I have different regional format - for you it is not an option. So:
1. To be on safe side, select column A and format it as General;
2. Into some empty cell in some other column (format General!) enter 1;
3. Copy the cell with number 1 you entered;
4. Select tha range with dates in column A;
5. Right-click on selection and select from drop-down menu Paste Special;
6. In pop-up Paste Special window, check radio button Multiply. Click OK;
7. Format the column A as "dd/mm/yyyy" or simply as Short Date.

[Pecoflyer]

Eventually select the range - Data - Text to columns - Finish

[p45cal]

Pecoflyer is absolutely correct.
To be really sure of a good result, makes sure to choose the date format in the 3rd step of the Text to Columns wizard, to match that of the source data (not what you want it to become). Once that's done, the cells will have Excel dates in and you'll be able to apply any format you choose to want to see them in:

[F.B]

Thank you guys. You were very helpful