10 Replies Latest reply on Nov 6, 2018 8:35 AM by Ombir Rathee

    #EasyQuestion: How to add up natural days for a month since the first registry

    Daniel Ferreyra

      Greetings Data Lovers!

       

      I'm trying to create a calculated field to count the number of natural days since the first entry; in other words, I would like to count the number of days between the first registry of the month (in this case 7 Feb 18) till the last day of the month( 28 feb) meaning (28 feb-7 feb=21  days). How can I express that into a calculated field in order to use it for every month?

      amarillo.PNG

      I attach the workbook in v 10.1. Please feel free to edit it, I'm working in the red sheets.

      Thanks for your time!