https://systematic.workato.com/t5/community-chat/number-of-work-days-between-two-dates/m-p/8202#M489 <P>To calculate the number of business days between two dates while excluding holidays, you can build a Workato recipe using a combination of triggers and actions.</P><P>Here's a simple pseudocode for the logic:</P><P>business_days_count = 0<BR />(start_date..end_date).each do |date|<BR />unless date.saturday? || date.sunday? || holidays.include?(date)<BR />business_days_count += 1<BR />end<BR />end</P> Fri, 15 Nov 2024 17:19:54 GMT timwolfe 2024-11-15T17:19:54Z https://systematic.workato.com/t5/community-chat/number-of-work-days-between-two-dates/m-p/8199#M486 <P>hello <span class="lia-unicode-emoji" title=":waving_hand:">👋</span>,</P><P>I just wanted to ask if anyone has any recommendations for a Recipe.</P><P>I'm trying to get the number of business days between two dates. The additional challenge is also to exclude holidays.</P><P>Do you have any tips? much appreciated.</P> Thu, 14 Nov 2024 23:29:56 GMT https://systematic.workato.com/t5/community-chat/number-of-work-days-between-two-dates/m-p/8199#M486 angeli2 2024-11-14T23:29:56Z https://systematic.workato.com/t5/community-chat/number-of-work-days-between-two-dates/m-p/8202#M489 <P>To calculate the number of business days between two dates while excluding holidays, you can build a Workato recipe using a combination of triggers and actions.</P><P>Here's a simple pseudocode for the logic:</P><P>business_days_count = 0<BR />(start_date..end_date).each do |date|<BR />unless date.saturday? || date.sunday? || holidays.include?(date)<BR />business_days_count += 1<BR />end<BR />end</P> Fri, 15 Nov 2024 17:19:54 GMT https://systematic.workato.com/t5/community-chat/number-of-work-days-between-two-dates/m-p/8202#M489 timwolfe 2024-11-15T17:19:54Z