Previous Business/working Day

(0) Share

Report

Posted on by Rat2

Hi Users,
Need your help please
I would like to get the yesterday working date. ( exclude weekends )
For example : Today is Monday then i need Friday date
Thank you in advance

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-mengmli-msft on at

Like (1)

Report
Copy link

Link copied!
Hi @Rat2 ,

Here is a method for your reference:
if(equals(dayOfWeek(utcNow()),1),addDays(utcNow(),-3),addDays(utcNow(),-1))

Best regards,
Rimmon

Was this reply helpful? Yes No