Hi
I have to two - "Target Going TAT Time (Day)" which is a text column and "Departure Date from Loading Point" which is a date column.
Now I want to add them together in a column called ETA (G) = Target Going TAT Time (Day) + Departure Date from Loading Point
The Problem i get an error when 1 of the column are blank, if Target Going TAT Time (Day) is blank and Departure Date from Loading Point has a date, I get #INVALID OPERATION
if Target Going TAT Time (Day) has a number and Departure Date from Loading Point is blank,Ii get an error of #DATE EXPECTED.
When I use the IFERROR it helps resolve the #INVALID OPERATION Error but I still get the #DATE EXPECTED error.
Please advise
