Forum Discussion

Copper Contributor

Apr 23, 2024

text to date

Need to transform the string which contain start and end date to seperat cell

MVP

Apr 23, 2024

Or:

=LET(md, TEXTBEFORE(B2, " -"), d, TEXTAFTER(md, " "), m, TEXTBEFORE(md, " "), y, TEXTAFTER(B2, ", "), DATEVALUE(d&"-"&m&"-"&y))

and

=LET(md, TEXTAFTER(TEXTBEFORE(B2, ","), "- "), d, TEXTAFTER(md, " "), m, TEXTBEFORE(md, " "), y, TEXTAFTER(B2, ", "), DATEVALUE(d&"-"&m&"-"&y))

Format the cells with the formulas as date, then fill down.