Add a planner task due date that excludes weekends

[milo1234]

can someone help with my flow please? 

I have a due date set to 3 days from the start date however I want it to exclude weekends. 

This is my flow:

[Rahber]

there is this function which is called dayOfWeek . if day of week is 0 or 6 that means its Saturday and Sunday.

So when you get today and the next 3 days having 0 or 6 in them you add 1 or 2 days depending on the value you get from dayOfWeek.

Example

Today is Friday that means its day of week 5 so this means you need to add 5 days instead of 3

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,
Rahber

[milo1234]

Hi @Rahber thank you for this. Are you able to incorporate this into my current flow please as I am a beginner with Power Automate? It would be much appreciated. 

[Rahber]

Before you create a task. Add a multi condition if. and use these conditions.

(dayOfWeek = 3 or 6 add 4 days OR if dayofWeek is 4 or 5 add 5 days else add 3 days) 

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,
Rahber

[milo1234]

@Rahber Sorry this doesn't help me much. Would you be able to mock up a quick example please? 

[milo1234]

@Rahber I have done this another way where you add 5 days if received date equals to 3 (Wednesday), and add 4 days if received date equals to 4 (Thursday), else add 3 days. 

I am getting an error message however not sure how to resolve - please find attached.