richiebkerry
Board Regular
- Joined
- May 4, 2016
- Messages
- 54
- Office Version
- 365
- Platform
- Windows
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" if nothing is in "AS" whilst keeping the format "dd/mm/yyyy"?
Thanks in advance
Richard
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" if nothing is in "AS" whilst keeping the format "dd/mm/yyyy"?
Thanks in advance
Richard