How to calculate business days

[Gal Fatal]

Hi

I am looking for a way to check if sum of epic estimations pass the  epic due date.

So I need to calculate if today+estimasions > due date - and consider the none working days.

Trivial. but do not find a good way doing it without app :(

Any idea ?

Thanks,Gal

[Tomislav Tobijas]

Yeah, this one is tricky @Gal Fatal ...

I haven't been able to find a decent solution as well. Boards within their configs do have this option to set non-working days, but that doesn't impact automation 🫤
I know I once considered trying to build a similar solution, but I just got tangled up, so I gave up hah

Here is one relevant feature request related to this: AUTO-971: When using BusinessDays, we should be able to define the non-working days and public holidays 

Hopefully, someone has found a workaround that you could use.

Cheers,
Tobi

[Peter_DevSamurai]

Hi @Gal Fatal

Yes, this can be achieved without apps but only for Jira Cloud Premium using Automation rules only. 

Jira doesn't natively sum estimates or handle non-working days in JQL, but automation can calculate the sum, add it to today (skipping weekends via plusBusinessDays), and compare to the Epic due date. If you're using the Jira Cloud Premium, I can list the set up steps for you. 

Best, 

Peter

[Gal Fatal]

@Tomislav Tobijas  thanks, yes if you can list the steps here it will help me (and maybe others too).

Thank you

Gal