Calculate business days excluding holidays in holidays list

HCL Domino Domino Forum
1

Count:= 0;noofdays:=0;

daystocomplete:=7;

FIELD Startdate:=CreationDate ;

varStartdate:=@Adjust (Startdate;0;0;daystocomplete;0;0;0);

FIELD holidays:=holidays;

@While(DaysToComplete >=noofdays;

noofdays:=@BusinessDays (Startdate;@Adjust (Startdate;0;0;daystocomplete+count;0;0;0);1:7;@Transform(holidays; “x”;@TextToTime(x)

));

Count := Count+ 1);

adjusteddate:=@Adjust (varStartdate;0;0;count -1;0;0;0);

@Prompt (“[ok]”;“days to be adjusted”;“count”);

REM {“Formatting of Date”};

month:=@Select (@Month(adjusteddate);“Jan”;“Feb”;“Mar”;

“Apr”;“May”;“Jun”;“Jul”;“Aug”;“Sep”;“Oct”;

“Nov”;“Dec”);

day:=@Text(@Day (adjusteddate));

day:=@If(@Day(adjusteddate)<10;“0”+day;day);

year:=@Text(@Year(adjusteddate));

day+“-”+month+“-”+year