1 Reply Latest reply on Jul 29, 2014 12:09 PM by Michael McAlpin

    Created working days in a month but need to add weekends as partial days

    Roy Lucio

      Hi everyone,

       

      Using the forums and posts of others I am using this calculation to figure out the shipping days in a month. DATEDIFF('day',#7/01/2014#,#8/01/2014# )- MIN(DATEPART('weekday',#8/01/2014#),6 ) - MIN(DATEPART('weekday',#7/01/2014# ),6 )

       

      My question is that I need to add weekends as half a business day.  For example this month shipping days looks like this.

      Shipping days                        Description

      22.0Base:  23.0 days in month
        less 1 holiday
      0.5Add:  0.5 days for the 5th and 6th
      0.5Add:  0.5 days for the 12th and 13th
      0.5Add:  0.5 days for the 19th and 20th
      0.5Add:  0.5 days for the 26th and 27th
      24.0 Total shipping days

       

      Is there a way to add to the calculation to make it total 24 shipping days for july?

       

      Thanks,

       

      Roy