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')
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.
