Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Count Working Days Only

Hi - I would like to filter issues which have been in a certain status for more than 3 days. However, I am only interested in working days. I understand that "-3d" would not work. Is there a way?

2 answers

2 votes
Rodrigo Rosa Atlassian Team Aug 25, 2015

Hello Mariola,

this previous answer might help you achieving what you need. 

Also, we have a feature request for it:


that conversation happened in 2015. is there a feature for it now??

We have a Days Elapsed Plugin for JIRA that might be able to help.

The recipe:

  1. Add a traffic light custom field
  2. Setup the calendars to indicate the working days
  3. Configure the thresholds such that 3 is red
  4. Fire a post function to trigger on the traffic light custom field upon status change
  5. You can query all the issues that exceeded 3 days by searching for red traffic light

Note: When the issue is resolved or closed, you need a post function to trigger off. Otherwise it will keep on counting.


Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you