# 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.

Output = Timeline end date + (Combinations of A B C D or E) = New due date

@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.