-x Working days from DATE

Platform discussions
,
1

I currently have a formula that -1 from the Install date if Installer is “V” and -5 days from the install date if installer is “M” however i need this to remove by working days which it isnt at the moment. how do i add this to the formula to change this?

the formula currently looks like this:
IF({Installer} = “V”,
ADD_DAYS({Install date}, -1),
IF(AND(
{Installer} = “M”,
OR({Depot} = “DF”, {Depot} = “DA”, {Depot} = “WH”, {Depot} = “WA”)
),
ADD_DAYS({Install date}, -5),
ADD_DAYS({Install date}, -1)
)
)

image

2

Hi, you could try a SWITCH function to change the number of days based on the day of the week. So for the first part, something like -

IF({Installer} = “V”,

SWITCH (WEEKDAY({Install date})
	1, ADD_DAYS({Install date}, -2),		
	2, ADD_DAYS({Install date}, -3),		
	ADD_DAYS({Install date}, -1),		
	)

)

See https://support.monday.com/hc/en-us/articles/360001276465-Available-functions-in-the-Formula-Column for more information
Function: SWITCH
Description: Checks if a condition on a specific value is met, if so, returns the result of that value, o/w returns the default result (if exists). The pattern is: SWITCH({Column}, “val1”, “result1”, [“val2”, “result2”], …, [“default”])
Example: SWITCH({Priority}, “High”, 3, “Medium”, 2, “Low”, 1, 0) => 2 (in case priority is “Medium”)

Let me know if this works.