Multiple Functions per Cell/Column

nlarson_PMC

Hi,

Is it possible for a single Cell/Column to have multiple functions and if so, how do you achieve it?

For reference, I am trying to track the amount of days between different date columns, however it might take a few hours/days to input the second date. Because of this the cell is filled with #Invalad Data Type.

Is there a way to combine =NETDAYS ([Ordered Date]@row, [Received Date]@row) *formula used to track the number of days* with =IFERROR(Ordered Date]@row - [Received Date]@row) *formula used to stop the #Invalad Data Type from showing*?

Any information would be helpful. Thank you!

Sameer Karkhanis

You have to nest the formula. See below,

IFERROR(NETDAYS ([Ordered Date]@row, [Received Date]@row), "")

Sameer Karkhanis

You have to nest the formula. See below,

IFERROR(NETDAYS ([Ordered Date]@row, [Received Date]@row), "")

nlarson_PMC

Thank you @Sameer Karkhanis!