Workday formula not working

ljbmhe

I have a date linked in from a separate schedule smartsheet and want to use the WORKDAY formula to calculate 10 business days from that date, but am getting an error and can't figure out what I'm doing wrong. The following formula is returning an #INVALID DATA error:

=WORKDAY([IDTF START]1, 10)

What am I doing wrong?

Hudson_TMR

https://community.smartsheet.com/discussion/6349/dates-dont-act-as-dates-if-linked-from-another-smartsheet

Hudson_TMR

If you remove the inbound link in IDTF Start does the formula work?

Hudson_TMR

https://community.smartsheet.com/discussion/6349/dates-dont-act-as-dates-if-linked-from-another-smartsheet

ljbmhe

https://community.smartsheet.com/discussion/comment/345096#Comment_345096

I need the inbound link since the schedules change, but yes, if I set both column types to Date the formula works normally.

ljbmhe

https://community.smartsheet.com/discussion/comment/345097#Comment_345097

The solution posted here worked, thanks!