i have ~100 rows of live data website this:
january 24th 12:30pm ninja party
january 31st 3:30pm classic party
how can google sheets recognize dates? doesn't recognize ordinal endings (e.g. th/st/rd).
thank you.
this formula might work want (amend a2:a range required):
=arrayformula(if(a2:a="",,(iferror(datevalue(left(a2:a,search(" ",a2:a)+2)),datevalue(left(a2:a,search(" ",a2:a)+1))))))
Comments
Post a Comment