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

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


      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"





      Thanks for any help!