Question

How to exclude weekends from date range calculation?

  • 31 August 2023
  • 1 reply
  • 160 views

I’m building a workflow to allocate hours to a resource based on a request form. In the form, i get the Start date and the end date from the user. 

I’m using the Compare dates action in Utilities, and I am getting the difference in total no. of days

My question - How do I exclude weekends from the total no. of days? 

Any help would be appreciated! 

Thanks! 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Rocketlane 

Good question.

You would have to use a Code step to do that type of advanced calculation.

You can try asking ChatGPT for help writing the code.

 

If you need help, consider hiring a Certified Zapier Expert.