How to calculate the weekly collections & average weekly collections
Hi
Please see the attached Excel & the P/T where I need to be able to calculate weekly collections as it is & their average. Data given is from 1st January up to today. I need to see the collection per each week per Month so that I need to create a list box namely week_collections (1st Week, 2nd Week,3rd Week & 4th Week etc ) thereby on a clik of 1st week say January, it should show me January 1st week collections, when it is 2nd week, 2nd week collections to be shown etc.
I think if we build up a week bucket through if statement in the script my desired out put could be made. But I fail to do this accurately hence please help me on this.
