Skip Holiday

[#1]

Hey

i want calculate a end date for a case which comes into the system based on its open date. but i want so skip the holidays if they fall in between.

I have the list of holidays. can some one suggest me something for this.

[SunilChauhan]

networkdays (start_date, end_date {, holiday})

example

networkdays ('2007-02-19', '2007-03-01') returns 9 

networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8 

you can add holidays seperated by comma at tha end in bracket

hope this helps

[#3]

Hi sunil thanks for the help but , I dont have the end date,  i want to calculate it using some criterias and skipping holidays, if they fall in between.

So i want some way by which i can skip the dates in my logic  when holiday falls.

[SunilChauhan]

we use calculated at place of enddate

or use variable for that

hope this helps

[jonathandienst]

Hi

I think what you are looking for is

LastWorkDate(<startdate>, <number of work days>, <holiday date 1>, <holiday date 2>, ....)

I usually store a the holiday dates in a variable as a comma separated, quoted list of dates. So then I call

LastWorkDate(OpenDate, 10, $(vHolidayList))

... for the 10th working day following OpenDate (including OpenDate, if it is a work date)

Regards

Jonathan