Networkdays with If

mbonner517

I am trying to run the networkdays formula based off a certain status. So what I am trying to accomplish is if the position status shows filled, how long did it take to fill? Here is the formula I am trying and I get the Unparseable error.

=IF([Position Status]@row='Filled',NETWORKDAYS([Submitted to HM]@row, [Overall Position Status Date]@row),[""])

Sandhiya07

Hi @mbonner517 ,

Hope you are good and Safe!

Could you please remove the last Square brackets from that formula and use like this,

=IF([Position Status]@row='Filled', NETWORKDAYS([Submitted to HM]@row, [Overall Position Status Date]@row),"")

Thanks,

Sandhiya P

Sandhiya07

Hi @mbonner517 ,

Hope you are good and Safe!

Could you please remove the last Square brackets from that formula and use like this,

=IF([Position Status]@row='Filled', NETWORKDAYS([Submitted to HM]@row, [Overall Position Status Date]@row),"")

Thanks,

Sandhiya P

mbonner517

Thank you for your response! That worked :)

Sandhiya07

Hi @mbonner517

That's Great!

Please accept the answer if it worked so that status will be changed to accepted.

Thank you!

Have a Good day!