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

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events