Invalid data type for Date Formula

CaraBart28

Hello,

I am trying to figure out what I am doing wrong. I keep getting invalid data type and I am not sure why, the source column and formula column are both set to date columns.

Here is the formula I am using, =WORKDAY([Date January Late Notification Sent]@row, 10), I am trying to figure out 10 working days from the date listed in the "Date January Late Notification Sent" Column, which is set as a date column in properties.

JamesB

@CaraBart28 Try putting a date in your Date January Late Notification Sent cell. Since your formula has no data to reference it errors out.

you could do this.

=IFERROR(WORKDAY([Date January Late Notification Sent]@row, 10)," ")

JamesB

@CaraBart28 Try putting a date in your Date January Late Notification Sent cell. Since your formula has no data to reference it errors out.

you could do this.

=IFERROR(WORKDAY([Date January Late Notification Sent]@row, 10)," ")

CaraBart28

@JamesB adding in the IFERROR worked, thank you so much!