calculate the difference in business days

[Chintan Patel]

Hello Community, 

The project board is currently have the below custom fields

 Due date

Target start
Target end

End date

IF I 

• use the ‘Target end’ date as a fixed/committed date to complete the task
• use the ‘End date’ as the actual end date of the task

is there a way to calculate the difference in business days between the ‘Target end’ and ‘End date’ and report on it?

if yes if someone can please provide the details steps as I am trying to learn. 

Thank you

[Walter Buggenhout]

Hi @Chintan Patel,

Make sure you first add a new custom field to your project (numeric) to store the value of the calculation.

Then, create an automation rule to calculate the difference between the target end and actual end dates. You should do the calculation when you take the action on your issue that really represents the end of the task. That would most likely be the moment you move it to the done status in your workflow. Based on that assumption, your automation would look like this:

Trigger: issue transitioned to status Done

Action: edit issue, set the following fields:

- End date > {{now}}

- your new field: {{now.diff(issue.Target end).businessDays}}

The formulas between {{ }} are so called smart values. They allow you to perform calculations in automation rules. For more context, you can read up on date calculations in this support article.

Hope this helps!  

[Chintan Patel]

Hello Walter,

Hope your day is going well!

Thank you so much for your help. I really appreciate your time and help with this. 

Kind regards,

Chintan