4 Replies Latest reply on Oct 29, 2018 12:57 PM by Taylor Wilson

    Count records with "Created Date" 2 or more weekdays in the past

    Taylor Wilson

      Hi,

       

      I'm struggling to create a calculated field that would count only the records where Created Date is 2 or more weekdays greater than today within a month. So for example, if my set looked like this...

       

      Records
      Created Date

      Record 1

      10/19/2018
      Record 210/5/2018
      Record 3

      10/13/2018

      Record 410/21/2018

       

      In this instance and looking at today's view of 10/22, it would only count records 2 and 3. Since 10/20 is Saturday and 10/21 is Sunday, records 1 and 4 would not meet criteria.

       

      Can anyone provide a solution?

       

      Thanks!