I want to find the Cancellation Deadline as a Date using a Formula Date field.
I have a [Start Date] field and
[Cancellation Notice] field of type Duration but I can change it to Numeric or text.
IF a class Starts on 11-6-2015 and the class has a 10 day Cancellation Notice prior to that Start Date, what would that formula look like.
WeekdayAdd([Start Date], -[Cancellation Notice]) validates but doesnt compute correctly.
Only when I do this:
WeekdayAdd([Start Date], -10) does it compute correctly
Obviously, I want it to pull from the field.which is numeric....
Thanks for your help.