Forum Discussion
Unable to extract month from date
Most probably Start Dates are texts which only looks like dates, not dates (which are actually numbers). The rest depends on which is default date format on your machine.
As variant you may transform texts to dates with Data->Text to Columns selecting MDY on third step.
Or
=TEXT( DATE(2021, LEFT([@[Start Date]],2), 1), "mmm")
Could you attach a copy of the workbook without sensitive/proprietary information?
Sergei Baklan already suggested using Data > Text to Columns.
Here is the result. I expanded the formulas to prevent them from returning "Jan" if the date has not been filled in.
HansVogelaar Hi, I have updated my data in the spreadsheet and when I go to Data > Text to Columns, the column changes the text to the actual formula.
Am I doing something wrong?Make sure the column is not formatted as Text.
If that is not the cause, make sure that the Show Formulas button on the Formulas tab of the ribbon is NOT highlighted.
- Thank you so much Hans!