HELP - 2 date custom fields 1 is a custom request date and 1 is a custom due date -2 days how to include holidays

[DawnmarieD]

I have a custom  "Requested Send Date and Time" field and a custom "Content Due Date" field. I can get that to work without issue. My problem is how do I account for holidays (identified in our Schedule).

My current result is:

standard date/time field = Requested Send Date and Time: Sept. 2, 2025, 11:00 a.m.

(ADDWEEKDAYS({DE:Requested Send Date and Time},-2) = Content Due Date: Aug. 29th, 11:00 a.m.

But it should be = Aug. 28th, 11:00 a.m. to accommodate for Sept. 1st being a holiday.

Can this be done within Workfront? I would like the requestor to see this when they submit the request so I'm trying to avoid sending it out through Fusion.

Thoughts?

[monicacardoso · Accepted solution]

Hi @DawnmarieD, 

Thank you for your question. I don't believe this would be possible without the use of Fusion because Workfront’s calculated fields do not allow you to select which schedule to use within the formula. As a result, the calculation will not take into account holidays or time off. 

- Monica