Really been trying to make this work, but it keeps throwing an error on me.
It says : "Formula Error -- Incorrect variable type.The type of the variable does not match the return type of the expression." Not sure what I am doing wrong. May just need a new set of eyes on this...
var date newyearse =[Holiday - New Years Eve];
var date newyearsd =[Holiday - New Years Day];
var date easter = [Holiday - Easter-GF];
var date memorial = [Holiday - Memorial Day];
var date julyth = [Holiday - July 4];
var date laborday = [Holiday - Labor Day];
var date thanksgivingt = [Holiday - Thanksgiving T];
var date thanksgivingf = [Holiday - Thanksgiving F];
var date christmase = [Holiday - Christmas Eve];
var date christmasd = [Holiday - Christmas Day];
var number a = [Duration];
var date start = [Start];
var number b = $a + If($newyearse >= $start and $newyearse <= WeekdayAdd($start, $a), 1, 0);
var number c = $b + If($newyearsd >= $start and $newyearsd <= WeekdayAdd($start, $b), 1, 0);
var number d = $c + If($easter >= $start and $easter <= WeekdayAdd($start, $c), 1, 0);
var number e = $d + If($memorial >= $start and $memorial <= WeekdayAdd($start, $d), 1, 0);
var number f = $e + If($julyth >= $start and $julyth <= WeekdayAdd($start, $e), 1, 0);
var number g = $f + If($laborday >= $start and $laborday <= WeekdayAdd($start, $f), 1, 0);
var number h = $g + If($thanksgivingt >= $start and $thanksgivingt <= WeekdayAdd($start, $g), 1, 0);
var number i = $h + If($thanksgivingf >= $start and $thanksgivingf <= WeekdayAdd($start, $h), 1, 0);
var number j = $i + If($christmase >= $start and $christmase <= WeekdayAdd($start, $i), 1, 0);
var number k = $j + If($christmasd >= $start and $christmasd <= WeekdayAdd($start, $j), 1, 0);
WeekdayAdd($start, $j)
