
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 05, 2021 01:00 PM
Hello,
I’m trying to create a formula that returns a workday date after 4 days are added. How do I adjust the field that is feeding the data, and the formula itself to always return a date that is on a weekday? It returns an “#ERROR” every time I try one of the formulas below.
DATEADD({Process Vetting Start Date},4,‘days’))
DATEADD(WORKDAY({Process Vetting Start Date},4,‘days’))
WORKDAY(DATEADD({Process Vetting Start Date},4,‘days’))
Thanks in advance
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 05, 2021 01:28 PM
The WORKDAY
function does not take a units parameter. Just the field name and the number of working days. It is documented in the formula field reference.
WORKDAY({Process Vetting Start Date}, 4)
If you answer is off by a day, you may need to adjust the timezone settings of the field format.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 05, 2021 01:28 PM
The WORKDAY
function does not take a units parameter. Just the field name and the number of working days. It is documented in the formula field reference.
WORKDAY({Process Vetting Start Date}, 4)
If you answer is off by a day, you may need to adjust the timezone settings of the field format.
