Thank you, but it's not recognizing the "and" after "Saturday" and the
"then" after "Sunday". I tried removing the end quotation mark after
EEEE or adding an opening quotation mark before EEEE but nothing is
making that code work:if (HasValue(Dates.Row1.TARGETSTART)) and
Num2Date(Date2Num(Dates.Row1.TARGETSTART.formattedValue, "MM-DD-YYYY")
EEEE")<>"Saturday" and
Num2Date(Date2Num(Dates.Row1.TARGETSTART.formattedValue, "MM-DD-YYYY")
EEEE")<>"Sunday") then(Dates.Row1.TARGETSTART.formattedValue,
"...