Are you looking for a way to automatically determine the last working day of each month in Adobe Workfront? If so, this post is for you!
Challenge:
Workfront doesn’t provide a direct option to fetch the last working day (excluding weekends) of a month in calculated fields. However, with a well-structured custom expression, we can dynamically determine it without any external tools or APIs.
Solution: Using a Calculated Field Expression
Below is an optimized expression to get the last working day of the current month using a Workfront calculated field:
IF(DAYOFWEEK(ADDDAYS({plannedStartDate}, DAYSINMONTH({plannedStartDate}) - DAYOFMONTH({plannedStartDate}))) = 1,
ADDDAYS({plannedStartDate}, DAYSINMONTH({plannedStartDate}) - DAYOFMONTH({plannedStartDate}) - 2),
IF(DAYOFWEEK(ADDDAYS({plannedStartDate}, DAYSINMONTH({plannedStartDate}) - DAYOFMONTH({plannedStartDate}))) = 7,
ADDDAYS({plannedStartDate}, DAYSINMONTH({plannedStartDate}) - DAYOFMONTH({plannedStartDate}) - 1),
ADDDAYS({plannedStartDate}, DAYSINMONTH({plannedStartDate}) - DAYOFMONTH({plannedStartDate}))
)
)
Key Benefits
Fully Automated: No need for manual updates each month.
Works for All Months: Handles different month lengths dynamically (28, 29, 30, 31 days).
No External Tools Needed: 100% Workfront native solution.
Weekend Handling: Ensures the date falls on a working day.
️ How to Implement in Workfront
Go to Workfront → Setup → Custom Forms.
Add a New Calculated Field and paste the above expression.
Save & Recalculate to see the last working day automatically update.
Feedback & Discussion
Let me know if this expression works for you or if you have any edge cases where it behaves unexpectedly. Happy Workfront automation!
