The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculate days between due date and date completed

harshada
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 7, 2018

We're trying to calculate the number of days between a project due date and when it was actually completed. 

 

Thanks!

2 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Aron Gombas _Midori_
Community Champion
June 19, 2020

You can also use the Better Excel Exporter app to implement this calculation.

The "H" and "I" columns are implement as difference between two point of times in this example, so this is very similar to your use case:

jira-issues-with-custom-calculated-fields

0 votes
Tuncay Senturk _Snapbytes_
Community Champion
August 7, 2018

Hello,

The more details you give to clarify, the more answers you get from the community.

AFAIU, you need to calculate the number of days between the date which issue was resolved and the date in 'due date' field.

Jira does not give you this out-of-the-box.

But, you can display due date, and resolution date in issue navigator, export to excel and calculate the days in Excel.

Or you can use some plugins:

- with script runner plugin you can create your own custom field which calculates this

- enhancer plugin gives some time duration custom fields that you may be interested in.

I hope it was helpful.

Best

TAGS
AUG Leaders

Atlassian Community Events