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...........