Solved: Help with WORKDAY() - Page 2

Cesar_Hernande1 · 07-23-2021 03:20 PM

Hello, could someone help me with this:
I have a creation date [FECHA DE CREACION].
I want to get a deadline [FECHA LIMITE], adding 8 hours from the creation date.
But I want the deadline to contemplate only business days from Monday to Friday and a schedule from 9:00 a.m. to 6:00 p.m.

I already tried workday, but I’m not getting what I’m looking for.

Suvrutt_Gurjar

Please try the below expression in [FECHA LIMITE]. You could make it more compact with more testing. Please test well.

IF(TIME( [FECHA DE CREACION])<=“10:00:00”,
[FECHA DE CREACION] + “008:00:00”,
DATETIME(WORKDAY(DATE( [FECHA DE CREACION]),1) + “009:00:00”) +
(“008:00:00” - (DATETIME(DATE( [FECHA DE CREACION])-“006:00:00”) -
[FECHA DE CREACION])
)
)

View solution in original post