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
4,359,822
Community Members
 
Community Events
168
Community Groups

How to calculate working days between two dates in JIRA Structure

Adi TK I'm New Here Aug 21, 2022

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.

 

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.

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

Suggest an answer

Log in or Sign up to answer
TAGS
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