6 Replies Latest reply on Nov 22, 2018 2:33 PM by Daniel Ferreyra

    Number of Sundays between two dates

    Daniel Ferreyra

      Greetings Data Lovers!

       

      I would like to create a calculated field to know the number of Sundays between an start date and an end date.

       

      Where the startdate is: MIN([Date])

      and the enddate is EOM, which its formula is: {FIXED YEAR([Date]), MONTH([Date]):MIN(DATETRUNC('month',DATEADD('month',1,[Date]))-1)}

       

      I have made the sum of the following calculated field for the number of Sundays

      Thanks!