Help

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

DATEADD WORKDAYS VALUE using a number field from a lookup

Topic Labels: Formulas
Solved
Jump to Solution
247 2
cancel
Showing results for 
Search instead for 
Did you mean: 
David_Bevan
5 - Automation Enthusiast
5 - Automation Enthusiast

 

Hey there. I came soooo close to getting a working formula for what I was trying to achieve but fell at the last hurdle.

I have a date field and a number field from a lookup. I am trying to create a formula that gives me a new date based on the the date field and the plus or minus number in the lookup number field. I am using this formula currently which is working and showing the new dates correctly.

DATEADD(Date, VALUE(Deadline&""),'days')

Screenshot 2024-09-24 at 14.43.17.png

 
 
I am trying to update this formula so that it only takes into account workdays but anytime I also try to add this, I get an error in my formula field:
WORKDAY(DATEADD(Date, VALUE(Deadline&""),'days'))
doesnt seem to work. Wondering if someone can see where I am going wrong.
 
Thanks in advance.
1 Solution

Accepted Solutions

Hello,

Try the formula:

WORKDAY(Date,Deadline)
 
It should work:
Pascal_Gallais_0-1727186963778.png

Regards,

Pascal

See Solution in Thread

2 Replies 2

Hello,

Try the formula:

WORKDAY(Date,Deadline)
 
It should work:
Pascal_Gallais_0-1727186963778.png

Regards,

Pascal

As easy as that, feel sheepish posting in the first place now 🤣