Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Assistance with Dateadd & Workday Formula

Solved
Jump to Solution
1441 0
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.