Calculate number of days count

[#1]

Hi,

     I need to find the number of working days between two fields where the work is til pending.

I've worked out with this expression and i couldn't acheive the proper count of it. Can anyone help me out to get the days count. Wil be so helpful for me.

This is what the expression i've used for that. please suggest me regarding this.

Expression used by me :

if(NetWorkDays([Job Task]<>'End',[Date 1],[Date 2]))

[Gysbert_Wassenaar · Accepted solution]

Try: if([Job Task]<>'End',NetWorkDays([Date 1],[Date 2]))

[#3]

Thanks Gysbert for helping me in this issue