I have a list of Holiday dates in a rollup field linked to another table. I tried to add that rollup list of dates to my WORKDAY Formula, but it’s producing an error. If I copy/paste the string of dates between ‘single brackets’ the formula works perfectly but I can’t surround the Holiday field in single brackets. Here is what I currently have:
IF({OE Date},DATETIME_FORMAT(IF({Deposit Hard Date},
{Deposit Hard Date},WORKDAY(DATEADD({OE Date},
{Deposit Due (Days)}-1,'days'),1,Holidays)),'MM/DD/YY'))
