Forum Discussion
Can i use FIND to search last occurence
So I have a string Complete Status 123@2023-03-01T16:25:51.094Z Status 456@2023-03-01T16:22:46.227Z| Status XYZ@2023-03-01T19:43:56.184Z Status 456@2023-02-28T18:24:23.7292| Status XYZ@2023-02-...
This 365 formula converts the string to elements of an array and works with those rather than continuing to process the string.
= LET(
finalStatus, TEXTAFTER(A1,"Status ",-1),
dateAndTime, TEXTSPLIT(finalStatus, {"@","T","Z"}),
SUM(VALUE(CHOOSECOLS(dateAndTime,{2,3})), - 5/12)
)