How to calculate working days between two dates in JIRA Structure

Question

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 Answer

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