Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to calculate working days between two dates in JIRA Structure

Adi TK I'm New Here Aug 21, 2022


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.


1 answer

1 accepted

1 vote
Answer accepted
Adi TK I'm New Here Aug 21, 2022

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

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Software

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

4,959 views 18 31
Read article

Atlassian Community Events