Skip to main content
Question

How to exclude weekends from date range calculation?

  • 31 August 2023
  • 1 reply
  • 207 views

Rocketlane

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.

Troy Tessalone
Forum|alt.badge.img+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.