Forum Discussion
Dates Columns imported from Planner are not correct
Salman_Alkweldy You need to transform the text dates in column H to real dates with Text-to-columns on the Data ribbon. Skip through steps 1 and 2 (i.e. change nothing). In step 3 set the data format to 'Date' and indicate that the texts are in 'DMY' format and Finish.
Now, Excel will transform the texts to real dates and display them in the default date format based on your local system settings.
Solution described does work partially. "Created Date" column got converted in MMM-DD-YYYY format however rest two columns i.e. "Start Date" & "Due Date" didnot converted. infact excel file is closing abruptly.
| Created Date | Start Date | Due Date |
| 03/08/2024 | 03/12/2024 | 03/15/2024 |
| 03/08/2024 | 03/08/2024 | 03/11/2024 |
| 03/07/2024 | 03/07/2024 |
Text to Columns work on column by column basis. That means you shall repeat the procedure for each column separately.
Based on your screenshot on third step of the wizard it shall be selected Date->MDY.
This tool is in Excel for dozens of years. If you do all correctly it shall work.
I stumbled upon this thread hoping for a resolution, but unfortunately excel keeps abruptly crashing (along with any other open/minimised excel files) as soon as I try doing the text to columns on the "Due Date" column. It is unfortunate that despite both being MS platforms, they are so incompatible. It's like Excel hates columns with Dates
