nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is it possible to identify the numbers of weekend-days in an active sprint?

Uwe Döll

Hi,

I want to get the Numbers of workingdays or weekenddays in my active Sprint. This is my Formula. I actual need the "-4" to remove the Weekends in my 3-Week-Sprint. Next week i have to change it to "-2", because there would be only one Weekend left.

with sprintzeit = DAYS_BETWEEN( NOW(), MAX(sprint.enddate) ) - 4

Is there a simple and automatic working formula, to identify the number of weekenddays or workingdays in an active sprint?

Best Regards,
Uwe

Accepted answers

Uwe Döll

not solved, but irrelevant.

The formula slows down the Structure extremely, so i decided to remove the formula completely.

All comments

Dave Mathijs

Hi @Uwe Döll , have you configured the Standard Working Days as well as the Non-Working Days in your agile board?

What would be the benefit of having this result?

Uwe Döll

@Dave Mathijs
in every Project, i have this configuration (Picture below). That does not work.

Uwe Döll

not solved, but irrelevant.

The formula slows down the Structure extremely, so i decided to remove the formula completely.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

structure

working-days

weekend