4 risposte
You may need to tweak the PST / UTC Offsets, but I think this might work OR(
AND(
WEEKDAY(DATEVALUE(NOW() - (8/24) )) = 6,
TIMENOW() >= TIMEVALUE("17:00:00.000")
),
WEEKDAY(DATEVALUE(NOW()- (8/24))) = 7,
AND(
WEEKDAY(DATEVALUE(NOW()- (8/24))) = 1,
TIMENOW() <= TIMEVALUE("16:00:00.000")
)
)