web

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

News and Announcements icon

Power Platform CommunityForums Power Automate t+2 exclude weekend

Power Automate

Answered

t+2 exclude weekend

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all

I had already written a T+2 expression but now I would like it to skip to Monday if the product of T+2 falls on Saturday and Tuesday if it falls on Sunday.

How should I rewrite the formula?

addDays(utcNow(),2,'dd-MM-yyyy')

Categories:

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
figured it out

if( equals( dayofweek( addDays(utcNow(),2)), 6), addDays(utcNow(),4,'dd-MM-yyyy'), if( equals( dayofweek( addDays(utcNow(),2) ), 0), addDays(utcNow(),4,'dd-MM-yyyy'),addDays(utcNow(),2,'dd-MM-yyyy')) )

Join the conversation