I created the date filter almost exactly same with the example worksheet. But, there is one problem;
F.e. when I choose the custom date as 20/05/2015 for comparing it weekly, it is taking the week from Monday to Sunday (18/04/2015-24/05/2015). However, we want 7 days back from 20/05/2015 (14.05.2015-20.05.2015) as the current week and the 7 days more back for the previous week. And, the same problem is also valid for months and years. Do you have any suggestions for that issue?
I appreciate your help.
Gamze
Hi Gamze,
The only way to do this is to put it in another sheet. I would recommend using the same calculation we did above to store 4 fields: Start Date 1, End Date 1, Start Date 2, End Date 2.
You can then use these fields in a sheet to show the range as well as in your period classification calculation.
Best,
Bryce
