Networkdays() Function??

[rohitians]

Dear Users,

I am using the following code

NetWorkDays(Sales_Mis_SALES_LOGIN_DATE,Sales_Mis_SANCTION_DATE,$(vHoliday)) as SANCTION_DAYS

I wanna pass mutiple days in vHoliday but i am not getting desired result,

vHoliday='11/11/2015','12/11/2015'

Request you to help.

Or Just suitable option to achieve thi I have set of 10 dates which should be avoided for calculation of sanction days.

Thanks and Regards,

Rohit

[sunny_talwar]

See if this helps:

vHoliday= Chr(39) & MakeDate(2015, 11, 11) & Chr 39, Chr(39) & MakeDate(2015, 12, 11) & Chr 39

[settu_periasamy · Accepted solution]

Good Explanation in the Below Document.

Find Net Working Days

[Kushal_Chawda]

try to provide Numbers instead of actual date in variable. for example 42326

[rohitians]

I have tried using this but it only accepts one date..

[tresB]

Are the dates in fields of similar formats? If so, try

•      remove '=' while defining variable
•      remove '$' from variable in networkdays()