Hello
I need help with calculating Due date based on some criteria: Here is an example:
=IFERROR(WORKDAY(H16,5,Sheet1!$B$2:$B$12),"")
Capture.PNG
I am using this formula to calculate due date. However, it only calculate due date based on contract date. However, If any time I have lender Name as : Net Direct" I would like to count due differently . Any deal with lender name :net direct" will be counted as 1 day after contract date, The rest are just 5 days as you can see above formula.
=IFERROR(WORKDAY(H16,5,Sheet1!$B$2:$B$12),"")
Bookmarks