murphybp2
Scholar

Re: Easiest way to calculate business days

Jump to solution

I think the link people are having issues with is the one that Giacomo Gelosi​ posted.  That link no longer works.

0 Kudos
Reply
jackgelo
Contributor

Re: Easiest way to calculate business days

Jump to solution

Hi Brendan Murphy​, thank you for pointing out that link change..

I'll edit my post to reflect the new link.

Reply
rhia
Scout

Re: Easiest way to calculate business days

Jump to solution

‌ -- 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?

Reply
jamesjack
Novice

Re: Easiest way to calculate business days

Jump to solution

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.

0 Kudos
Reply
skr35
Scholar

Re: Easiest way to calculate business days

Jump to solution
Calculate 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:

 skr35_0-1650469875387.png

  1. 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
  2. Calculate Date Action - adds varDaystoAdd to current date and stores in date variable, varDueDate
  3. Set Variable Action - finds the day of the week varDueDate is: 
    1. use function:  fn-FormatDate(varDueDate, "dddd") store in varDay
    2. "dddd" will output the day of the week written out ex) "Friday", "Saturday" or "Sunday"
  4. Log day - i used this just to record varDay for troubleshooting purposes
  5. Conditional Statement - is varDay = value of Saturday?
    1. If Yes, add 2 days to due date
      1. Date is varDueDate, put value of 2 in Days field and store again in varDueDate
      2. If No, nothing happens
  6. Conditional Statement - is varDay = value of Sunday?
    1. If Yes, add 1 day to due date
      1. Date is varDueDate, put value of 1 in Days field and store again in varDueDate
      2. If No, nothing happens

         

0 Kudos
Reply