HELP - 2 date custom fields 1 is a custom request date and 1 is a custom due date -2 days how to include holidays | Community
Skip to main content
D
DawnmarieD
Level 5
August 27, 2025
Solved

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

  • August 27, 2025
  • 1 reply
  • 201 views

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?

Best answer by monicacardoso

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

1 reply

M
Adobe Employee
monicacardosoAdobe EmployeeAccepted solution
Adobe Employee
September 3, 2025

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

Terms & ConditionsAccessibility statement

Loading footer...