Divide Current Month into 5 weeks, Week starting Friday and ending Thursday.

[sandeepmahajan]

Hi All,

Im trying to create a dashboard with clustered column graphs, displaying weekly data from monthly sheet. My week starts on Friday and ends on Thursday. Im using this formula to divide month into weeks:
=CONCATENATE("WEEK ",IF(WEEKNUM(D9+2,1)=1,1,((WEEKNUM(D9+2,1)-WEEKNUM(DATE(YEAR(D9),MONTH(D9),1),1)+1))))

So for month of Jan 2017, week 1 will be : 30 Dec 2016-05 Jan 2017. and week 5 will be 27 Jan 2017-02 Feb 2017.

I save each monthly data in monthly folders. So what i want is, get week 1 data from previous month file folder and current month file, friday to thursday. and week 5 data from current month file and next month file folder. This will change for each month automatically.
Please if anyone can help me with any ideas how can i do that?

Thanks in Advance.

Regards.