Date Formula - IF Statement Error
I have a date- formula field with the below working if statement: If(IsNull([PO Issue Date]) = false, WeekdayAdd([PO Issue Date], [Lead Time +Transit Time (Weeks)]*7), WeekdayAdd([Plan Issue PO D...
Forum Discussion
You had an error in the first part of your IF statement. This should give you the output you are looking for.
If(IsNull([Lead Time +Transit Time (Weeks)]),null,
If(IsNull([PO Issue Date]), WeekdayAdd([PO Issue Date], [Lead Time +Transit Time (Weeks)]*7), WeekdayAdd([Plan Issue PO Date], [Lead Time +Transit Time (Weeks)]*7)))
If(IsNull([Lead Time +Transit Time (Weeks)]),null,
If(IsNull([PO Issue Date]), WeekdayAdd([PO Issue Date], [Lead Time +Transit Time (Weeks)]*7), WeekdayAdd([Plan Issue PO Date], [Lead Time +Transit Time (Weeks)]*7)))
Give some thought as to whether you need to multiply the # of weeks by 7 or by 5 to get the correct WeekdayAdd result.