User Profile

Russ_Rimmerman

Microsoft

Joined Nov 02, 2018

103 Posts58 LikesLikes received

View All Badges

User Widgets

Recent Discussions

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")
Jan 05, 2022 Place SharePoint
microsoft lists
SharePoint Online
9.3KViews
0likes
1Comment

Recent Blog Articles