Expand my Community achievements bar.

Submissions are now open for the 2026 Adobe Experience Maker Awards.

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

Avatar

Level 3

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?

0 Replies