1 Reply Latest reply on Feb 26, 2016 10:12 AM by pooja.gandhi

    Calculate the number of days (Name) per month per year

    Maria Eugenia Alzate Londoño

      I need to calculate the average sales per day (Monday, etc) by month and year, which would be the sum of sales date (Monday, etc) divided by the number of days (Monday) per month per year.

       

      Captura de pantalla 2016-02-26 12.22.37.png

       

      For example: How to calculate the number of Monday in each month of each year?

      January: 4

      February: 2

      March: 4