Hi Everyone,
Is I want to exclude weekends and holidays in my "Wait" condition automation but my code is not working in "Period", "CONCATENATE(WORKDAY([Timestamp],2,Holidays[Holidays]))".
is there other way to do that other than WORKDAY()?
Hope you can help me. Thanks in advance.
The "Period" field expects a duration value. I imagine you would calculate the WORKDAY() result for x days in the future that you're wanting, then subtract NOW() from that to obtain the wait duration.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |