Jira automation: How to increment a Date Field by Business Days Based on a Custom Number Field

Platform Notice: Cloud - This article applies to Atlassian products on the cloud platform.

Summary

Jira Automation Rule to Increment a Date Based on a Custom Number Field, Excluding Weekends

Solution

Use case:

Automatically update the Due date based on a number custom field and the creation date, excluding weekends. For example, if an issue is created on September 25, 2024, and the custom number field specifies 4 days (named daysWorking in below example), the due date should be set to October 1, 2024.

To achieve this, you can utilize the below smart value expression.

{{issue.created.plusBusinessDays(issue.daysWorking)}} 



Last modified on Oct 15, 2024

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.