Getting #UNPARSEABLE error with NETWORKDAYS formula

DVC

Hello forum, I would really appreciate your help with this #UNPARSEABLE error

=NETWORKDAYS([Start Date] @row, [Closed Date] @row)

Thank you!

Paul McGuinness

HI @DVC

Its the spaces between the column refs and @row it needs to be all together

=NETWORKDAYS([Start Date]@row, [Closed Date]@row)

This should work now

Thanks

Paul

DVC

Thank you Paul & Paul. You're awesome. It worked!

DVC

It worked! Thank you Paul

Paul Newcome

Try removing the spaces before the "@row" bits.

Paul McGuinness

HI @DVC

Its the spaces between the column refs and @row it needs to be all together

=NETWORKDAYS([Start Date]@row, [Closed Date]@row)

This should work now

Thanks

Paul

Paul Newcome

Paul says to remove the spaces then Paul says to remove the spaces.

@Paul McGuinness Is this how an echo works online?🤣

Paul McGuinness

lol @Paul Newcome

There's some matrix Deja vu thing happening here!

DVC

Thank you Paul & Paul. You're awesome. It worked!

DVC

Sorry... don't mean to abuse your kindness or overburden you.

The NETWORKDAYS formula is being used in a Days column to calculate a task aging. The column data type is text/number. The formula itself worked as you advised but when converted it to Column Formula I got an #INVALID DATA TYPE error msg

Paul Newcome

@Paul McGuinness It looks like we might have hit a few of the same posts at the same time today. Haha.

@DVC Try an IFERROR like so:

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

DVC

It worked! Thank you Paul

Paul Newcome

Happy to help. 👍️