Convert text column to date column using calculated columns


Hi all,

I have a text column in a sharepoint list that has dates in it in this format:

Jan 30, 2022 to Feb 02, 2022


I want to make two new date type columns, one that shows the Jan 30, 2022, and another that shows the Feb 02, 2022.  I've tried all kinds of combinations with LEFT, MID, DATE, etc and my new calculated Date column only keeps displaying a "1".  Any tips?

To get the first date, I've already tried =TEXT(DATE(LEFT(StartDate,3),MID(StartDate,5,2),MID(StartDate,9,4)),"MMM DD YYYY")

1 Reply