Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Confiform date excluding weekends (sat and sund)



I have created a form to set a target date from its assigned date.

But I can't able to exclude weekend in that formula as i want just business days to be calculated.

I have created fields with assignedDate and targetDate 

With the help of definition rules set the target after 21 days  

But it is including sat and sunday.

I want to exclude sat and sunday please help me.


Formula :- 

TargetDate=([entry.assigneDate.timestamp] +1814400000)


1 answer


Sorry to say, but at the moment ConfiForms does not have any built-in functions to help you with handling "business days"

I have added this as a feature request to our internal Jira


I have the same issue as requested here. Do you have an update on the solution for calculating only business days?

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

Miss the Confluence demos at Team 21? Watch them here!

Phew, Atlassian Team 2021 blew by. With dozens of demos and a handful of keynotes, you may have missed some of the awesome Confluence Cloud sessions. Don't' worry, you can watch them all here or on Y...

196 views 2 5
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you