Help with using Networkdays as a column formula

hjarriaran

I want to create a column Formula that captures the Start Date and End Date in Networkdays but does not show the Invalid Data Type error for every unused column.

Trying to do this without using dependencies since I want more freedom with the start/end dates to be driven by the status rather than input.

I tried to use IF but can't seem to make it work.

Peggy Parchert

Hello @hjarriaran

Wrap your formula in IFERROR to stop the #INVALID DATA TYPE

=IFERROR(NETWORKDAYS([Start Date]@row, [End Date]@row), "")

Hope this helps

Peggy

Peggy Parchert

Hello @hjarriaran

Wrap your formula in IFERROR to stop the #INVALID DATA TYPE

=IFERROR(NETWORKDAYS([Start Date]@row, [End Date]@row), "")

Hope this helps

Peggy

hjarriaran

Thank you! It did.