I want to calculate duration from X days to Y days excluding weekends.

[Vipin Kumar]

Please help me out with JQL query

[Marc - Devoteam]

Hi @Vipin Kumar 

This can't be done with a JQL query.

Automation could help out with this.

Look into the following; jira-smart-values-date-and-time 

Aslo there are multiple previous community post around this topic, see: How-do-I-calculate-the-duration-in-days-hours-minutes-between 

What have you tried so far, this community is to help people out, and hopefully strengthen their knowledge.