Count 3 Business Days from calculated date

(1) Share

Report

Posted on by StillLearning_

Hi There,

I have a flow which creates a reminder a few days before the event starts but I need it to count business days only.

Currently I am using the "calculate time" function to subtract 3 days to the start date of the event. What I need to do however is subtract 3 business days to the start date of the event, so that if the event starts on Monday, the reminder will be set for Wednesday. likewise if the event starts on Wednesday the reminder should be set for Friday.

Is there a way to do this??

If so - how?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @StillLearning_ ,

Please try:

if( or(equals(dayOfWeek(StartDateOfTheEvent),4),equals(dayOfWeek(StartDateOfTheEvent),5)), addDays(StartDateOfTheEvent,-3), if( equals(dayOfWeek(StartDateOfTheEvent),6), addDays(StartDateOfTheEvent,-4), addDays(StartDateOfTheEvent,-5) ) )

Best Regards,

Bof

Was this reply helpful? Yes No
StillLearning_ 38 on at

Like (0)

Report
Copy link

Link copied!

Where should I try this ?

I am currently using the 'subtract from time' function (below) - how / where do I insert the below formula? is it a compose function or ?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @StillLearning_ ,

Please try:

if( or(equals(dayOfWeek(outputs('Create_event_(V2)')?['body/start']),4),equals(dayOfWeek(outputs('Create_event_(V2)')?['body/start']),5)), addDays(outputs('Create_event_(V2)')?['body/start'],-3), if( equals(dayOfWeek(outputs('Create_event_(V2)')?['body/start']),6), addDays(outputs('Create_event_(V2)')?['body/start'],-4), addDays(outputs('Create_event_(V2)')?['body/start'],-5) ) )

Best Regards,

Bof

Was this reply helpful? Yes No
StillLearning_ 38 on at

Like (0)

Report
Copy link

Link copied!

Thank you! that works now!

Can I assume that in order to adjust the number of business days to count I just add or reduce the "-3" "-4" "-5" equally?

Was this reply helpful? Yes No