web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Previous Business/work...

Power Automate

Answered

Previous Business/working Day

(0) Share

Report

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:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-mengmli-msft Microsoft Employee 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

Join the conversation