How to calculate working days between two dates in JIRA Structure

[Adrian TK]

Hi,

I'm trying to calculate Duration for working days only, between two dates.

My formula displays the Duration calendar days.

IF End_Date AND Start_Date:
    End_Date - Start_Date

I've set the output to "Duration" and "Work time" checkbox is ticked.

[Adrian TK · Accepted solution]

I found the solution in another thread. The formula will remove the weekend days.

https://community.atlassian.com/t5/Jira-Software-questions/How-to-calculate-calendar-days-between-2-Jira-date-fields-in/qaq-p/1775649

WITH raw_days = days_between(start, finish) + 1 :
WITH weeks = floor((raw_days + weekday(start)) / 7) : 
raw_days - weeks * 2