kwstroud
Design Dabbler

Adding Business Days

Is there an easy way to add Business Days in a formula?  I am looking for something that gives me a date 10 business days from today's date.

0 Kudos
Reply
5 Replies
devinweber
Forms Fledgling

Re: Adding Business Days

Definitely an out of the box workaround here, but this is what I dreamed up in a few minutes:

 

 

Launch Excel

 

Cell A1: =TODAY()

Cell B1:  10

Cell C1 (change this to Date format):  =WORKDAY(A1,B1)

 

Copy C1 and paste clipboard into a variable:  Data --> Set Variable --> Computer --> Windows Clipboard Value

 

 

0 Kudos
Reply
kwstroud
Design Dabbler

Re: Adding Business Days

Thanks - Hoping to find something that doesn't involve opening other applications.
0 Kudos
Reply
devinweber
Forms Fledgling

Re: Adding Business Days

Completely understand.  If you do a search in the community, it looks like others have posted regarding business day calculations.  There may be some more advanced solutions out there.  It would be nice if the dev team adds the workday formula to their bag of tricks.

0 Kudos
Reply
kbarton
Forms Fledgling

Re: Adding Business Days

Hi kwstroud,

 

  Are you needing to ignore holidays as well?  if so then you would need an internal holiday calendar to ignore those as companies have different holidays from each other.

 

  Otherwise you will need to use a couple if statements checking the [[*Day_of_week] and adding the appropriate days (?DateAdd("d",number of days,[*Date])].  If that date ends on a weekend, keep adding 1 day until you get to a weekday.  I used a loop for that part.  

 

Hope that helps.

 

Kyle

0 Kudos
Reply
kwstroud
Design Dabbler

Re: Adding Business Days

Thanks Kyle - Sounds like the best option.
0 Kudos
Reply