Forum Discussion
Solved
Convert text to date
Hi All, I need help with this issue please , I have this column with ages written in format like for example ( 2 years , 1 year , 13 month , 8 weeks ) I want to convert all these data to reflect ...
Practically the same with Beta functions
=LOOKUP(LEFT( TEXTAFTER( texts, " ") ), {"m","w","y"}, {1,0.25,12} )*TEXTBEFORE( texts, " ")