What is the easiest way to calculate business days? Is there an inline function that can do this? I have a requirement where I need to set the due date of a task to be 14 business days from the current date. I had seen on the old site where there was discussion of future builds of Nintex handling this, but wasn't able to find if that had happened or not. Anyone know?
Solved
Easiest way to calculate business days
Best answer by jackgelo
Hi Brendan,
on the old forum, Christian Bauer has said he has realized a User Defined Action to do what you're trying to do, here you are his site where you can download the UDA: dox42 Workflow Utils
I haven't tried it yet but I was very curious to know if it works correctly or not..in his site you can find his brief introduction to the use of the action
Giacomo
Edited on 20/05/2016 to update the link
+3- Nintex Employee
Hey Brendan
What product are you trying to implement this on? Workflow 2010/2013 or online?
Thanks
Siddhesh
Translate
Hi Brendan,
on the old forum, Christian Bauer has said he has realized a User Defined Action to do what you're trying to do, here you are his site where you can download the UDA: dox42 Workflow Utils
I haven't tried it yet but I was very curious to know if it works correctly or not..in his site you can find his brief introduction to the use of the action
Giacomo
Edited on 20/05/2016 to update the link
Translate
Thanks, I had seen that one. But I had also seen discussion of a Nintex enhancement. I was hoping there might be something a little simpler.
Translate
I had seen some discussion on the old forum of this feature being added to Nintex, but don't know what happened to it. So I submitted an idea. If anyone would like to vote it up, here's the link. Inline Function or Action to Calculate Business Days/Hours – Customer Feedback for Nintex
Translate
+4Hi,
I would totally love this feature and have voted for it.
Crazy this is not implemented yet, as in task reminders it is already possible.
Regards
Translate
+2Hi Brendan,
The link you had to another post is no longer valid. Do you know if there is another link or anyone else that may have a solution to this?
Thanks,
BJ
Translate
+5I've outlined an approach to calculating business days using Nintex Workflow here Holiday Booking Workflow: Identifying Weekends & Public Holidays
Translate
I think the link people are having issues with is the one that Giacomo Gelosi posted. That link no longer works.
Translate
Hi Brendan Murphy, thank you for pointing out that link change..
I'll edit my post to reflect the new link.
Translate
+15 -- this (UserVoice item) is one that's still out here and very voted up! Haven't seen updates on it.. anything you can tell us?
Translate
The function calculates the number of workdays between two dates in Excel. When using the function, the number of weekends is automatically excluded. It also allows you omegle to skip specified holidays and only count business days. It is categorized in Excel as a Date/Time Function. You can use this formula to calculate working days in Excel between two dates.
Translate
+1Calculate a task due date to business days only
I'm posting my solution for this common issue here in the hopes to help other users who have similar requirements to assign Flexi-tasks to users on Business Days only. I had seen on nintex community that there was a UDA created for this but it didn't work properly for me (due dates were just blank). I am using SharePoint 2013.
Here is my manual workaround that has been working very well for my workflow:
- Query List Action - this is used to query a list we have on our site where the number of days to complete a task is stored. This is used to find the appropriate number of days given certain conditions but if your days are standard for all tasks this is not necessary. Output is a number variable, varDaystoAdd
- Calculate Date Action - adds varDaystoAdd to current date and stores in date variable, varDueDate
- Set Variable Action - finds the day of the week varDueDate is:
- use function: fn-FormatDate(varDueDate, "dddd") store in varDay
- "dddd" will output the day of the week written out ex) "Friday", "Saturday" or "Sunday"
- Log day - i used this just to record varDay for troubleshooting purposes
- Conditional Statement - is varDay = value of Saturday?
- If Yes, add 2 days to due date
- Date is varDueDate, put value of 2 in Days field and store again in varDueDate
- If No, nothing happens
- If Yes, add 2 days to due date
- Conditional Statement - is varDay = value of Sunday?
- If Yes, add 1 day to due date
- Date is varDueDate, put value of 1 in Days field and store again in varDueDate
- If No, nothing happens
- If Yes, add 1 day to due date
Translate
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.