Using a Formula to output a new date based off a timeline end date and dropdown selections

Hi Guys,

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

Your help is much appreciated.

@JustinB1994

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.

IF({Timeline#End}, 
FORMAT_DATE(
WORKDAY({Timeline#End}, 
IF(FIND("A,", {Dropdown} & ","), 2, 0) + 
IF(FIND("B,", {Dropdown} & ","), 5, 0) + 
IF(FIND("C,", {Dropdown} & ","), 10, 0) + 
IF(FIND("D,", {Dropdown} & ","), 15, 0) + 
IF(FIND("E,", {Dropdown} & ","), 20, 0) 
) 
,"MMM DD, YYYY")
, "")

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Column Total in monday.com Formulas? YES!!!
Check out our monday apps, now in beta: The Monday Man Apps

1 Like

Thanks Jim,

This worked a treat, and thank you for the link to the Monday Hidden functions.

Cheers.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.