0 Replies Latest reply on Jun 27, 2012 1:44 PM by bruce lomasky

    Computing work days between 2 days

    bruce lomasky

      Perhaps there is a simpler (easier?) formula, but I wanted to share what seems to work for me:

       

      (DateDiff('day', [entered], [shipped]) + 1) - (DateDiff('week', [entered], [shipped]) * 2)

      - IIF(DateName('weekday', [entered]) = 'Sunday',1,0) - IIF(DateName('weekday', [shipped]) = 'Saturday',1,0)

       

       

       

      Bruce