Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Assistance with Dateadd & Workday Formula

Topic Labels: Formulas
Solved
Jump to Solution
2012 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Aysia_Saylor
6 - Interface Innovator
6 - Interface Innovator

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

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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.

See Solution in Thread

1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

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.