sandeepmahajan
New Member
- Joined
- Jan 4, 2017
- Messages
- 1
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.
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.