Forum Discussion
How to convert Text to Date?
I've extracted a sheet like this with a webscrapper tool but it formates dates like this - is there a formula etc to make sure it formats it into a mm/yy format? Even if it says 3 years ago, wo...
As variant
=LET(
period, SUM( ISNUMBER( SEARCH({"week","month","year"}, A1 ) )*{0,-1,-12} ),
amount, IFERROR(--LEFT(A1, FIND(" ", A1)-1 ), 1),
IF( period = 0, TODAY()-7*amount, EDATE( TODAY(), amount*period) )
)