I am trying to setup a formula to determine a due date output which adds business days (mon,tues,wed,thur.fri) depending on the selected dropdown options to an existing timeline end date.
For example…
Initial timeline dates Jan 29 - Feb 5
Dropdown entries.
A = 2 business days
B = 5 business days
C = 10 business days
D = 15 business days
E = 20 business days
Output = Timeline end date + (Combinations of A B C D or E) = New due date
This formula uses two undocumented functions WORKDAY() and FIND()… you can find out more about some of the undocumented functions here: The monday Hidden Functions.