#Date expected error

Morena

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

Morena

@Paul Newcome

Hi Paul

the formula is working now, i swapped the two columns, please see pic below

Paul Newcome

You will need to put it in a text/number column.

Morena

@Paul Newcome

When change the column type to text/number, i get numbers instead of dates

Paul Newcome

How exactly is the Departure Date from Loading Point column populated, and have you confirmed that it is in fact set as a date type column in the column properties?

Morena

@Paul Newcome

The values are entered manually on Departure Date from Loading Point rows

Yes, Departure Date from Loading Point column is a date type

Paul Newcome

And exactly what formula are you currently using?

Morena

@Paul Newcome

Hi Paul

this is my formula

Morena

@Paul Newcome

Hi Paul

the formula is working now, i swapped the two columns, please see pic below

Paul Newcome

That was going to be my suggestion (adding days to the date instead of adding a date to the days). I'm glad you were able to get it figured out.