Forum Discussion
Solved
Unable to extract month from date
Hi, I have used the correct formula =TEXT(I2, "mmm") however the month is not being extracted from the date. The start date column has a data type of 'Date' and the Month column has a data type of 'C...
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")
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")