Automate my excel sheet with formulas (need to update dialy, weekly, monthly)

  • I want to prepare a dilay and weekly and monthly report based on the fields given in sheet 1 (DPR) and in daily sheet sum up all the fields related to that date and enter automatically in the respectives fileds or column like wise sumup the fileds based on the dates given range and fileds in 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 and monthly sheet and based on the data in sheet1 (DPR) all the fields get updated...


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


    In Dialy sheet there are 3 segments presented under no of jobs done based on the data enter in DPR it should sumup all the fields and enter the total related to the 3 segments ... (3 segments presented in column O, P, and Q )


    Example check yellow colored it was done manually.... based on that date criteria in DPR Sheet and column E....


    Please do the needful....