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
  • 207 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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
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 Support
monicacardosoAdobe SupportAccepted solution
Adobe Support
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...