COUNT AND SUM FUNCTION BY DIALY, WEEKLY AND MONTHLY

  • Hi,


    I have data i need to count of fields based on the data by dialy, weekly and monthly.



    Weekly format : 03/01/2020-03/07/2020 , 03/08/2020-03/14/2020 .......................................... (this can be done through formula)

    Monthly format : 03/01/2020-03/31/2020 , 04/01/2020-04/30/2020 ........................................ (this can be done through formula)


    Above two columns are in weekly report and monthly report sheet and based on the data in sheet1 all the date fields get updated in weekly and monthly


    Just count and sumup all the fileds based on dates (Dialy, weekly, monthly)



    PFA and do the needful ...


    Thanks in advance...........


    :)

  • Hi,


    Thanks for replying and i have attached a word document clearly mentioning my requirement, can you please review once and if you need any further clarification am ready to provide all the data and thanks for replying....



    :):):)