Date formula not adding days

Jenn Burk

I'm trying to add "days" to a Date.

The formula in the "Test" column is:

=[Ex Works]@row + (IFERROR(INDEX({business days}, MATCH(Location@row, {location}, 0)), ""))

This is the error that I'm getting. I'm not sure what I'm doing wrong.

Alan P.

I was able to get it to work.

1. Made sure the first column was a 'Date' column (Used the second column)
2. 'Test' column must be a 'Date' column as well
3. Add this formula to your 'Test' column: =[Ex Works]@row + [Business Days]@row

I hope this helps

Alan P.

You're welcome :)

Alan P.

I was able to get it to work.

1. Made sure the first column was a 'Date' column (Used the second column)
2. 'Test' column must be a 'Date' column as well
3. Add this formula to your 'Test' column: =[Ex Works]@row + [Business Days]@row

I hope this helps

Jenn Burk

OMG! I had the "Test" column as text, not a date.

I can't believe that I didn't see that.

Thank you so much!!!!

Alan P.

You're welcome :)