2 Replies Latest reply on Jun 12, 2012 6:24 AM by kathryn.chrismer

    Exclude Sat-Sun from day-over-day calculation?

    kathryn.chrismer

      Does anyone know how to edit this formula to exclude Saturday and Sunday?

       

      Right now it shows me yesterday and the same day last week, but I'd like to exclude Saturdays and Sundays. So, if this report is being shown on a monday it would show Friday and the previous Friday instead of Sunday and the previous Sunday.

       

      if([Calendar Date]=Today()-1) Then "Yesterday"

      elseif([Calendar Date]=Today()-8) Then "Last Week"

      Else "Ignore"

      End

       

       

       

      Thanks for any help!