NetworkDays script

[ivandrago]

Hi,

I have the attached Document, I have a Holidays worksheet and a Orders Worksheet.
I want to use the Function NetworkDays againts the DateEntered, DateInvoiced fields and
using the Holidays to exclude the days between.
But I am having trouble trying to do this via the script?

Thanks

[ivandrago]

Anyone?

[aveeeeeee7en]

Hi Ivan

See the Attachment.

Hope it works for you.

Regards

Aviral Nag

[aveeeeeee7en]

If you want Number of Days excluding Holidays than see the Attachment.

[ivandrago]

Hi,

Thanks for your reply, but the results that you have provided are not what I wanted? I was expected to see the following results, basically I want to see how many working days are between DateEntered and DateInvoiced and to exclude the holidays from the result set.

OrderId	DateEntered	DateInvoiced	DaysOld
1	01/05/2013	01/07/2013	42
2	09/12/2013	22/01/2014	30
3	22/03/2014	22/03/2014	0
4	12/12/2013	25/03/2014	71
5	24/12/2013	24/12/2013	1
6	24/12/2013	30/12/2013	3
7	25/12/2013	02/01/2014	4

Thanks

[maxgro · Accepted solution]

see attachment, this is the RESULT

using your qvw

and variable h =chr(39) & concat(Holidays, chr(39) & ',' & chr(39)) & chr(39)

and expression =NetWorkDays(DateEntered, DateInvoiced, $(h))