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.

DATEADD WORKDAYS VALUE using a number field from a lookup

Topic Labels: Formulas
Solved
Jump to Solution
564 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
Pascal_Gallais-
9 - Sun
9 - Sun

Hello,

Try the formula:

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

Regards,

Pascal

See Solution in Thread

2 Replies 2
Pascal_Gallais-
9 - Sun
9 - Sun

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 ðŸ¤£