I currently have data in cell AS2396 "04/11/2019 10:49:09", this then gets formatted to in BM column to read "04/11/2019" using formula "=TEXT(AS2396,"dd/mm/yyyy") and the world is great.
However, if no data is in column "AS" and say its in column "C", how can I add an if error to to select "C"...