Monthly Target Divide by Weekly

[hardeep.kanwar]

Hi Experts

How can i Divide my Monthly Target into Week Wise

But, For 1st Week Not to Include Sunday

For 2nd Week Not Include Saturday and Sunday

For 3rd and 4th Week Not Include Sunday


Below is the Example of my Data

How can i Calculate the Target of "AHMEDABAD"

Excel Workbook
	K	L	M
4	Campus	FS	Grand Total
5	AHMEDABAD	20	20
6	AURANGABAD	24	24
7	BANGALORE	132	132
8	BHUBNESHWAR	32	32
9	CHANDIGARH	36	36
10	CHENNAI	104	104
11	DELHI	176	176
12	GOA	32	32
13	HUBLI	24	24
14	HYDERABAD	84	84
15	INDORE	48	48
16	JAIPUR	52	52
17	JAMMU	20	20
18	KATHMANDU	20	20
19	KOLKATA	124	124
20	LUCKNOW	56	56
21	MUMBAI	224	224
22	NAGPUR	48	48
23	NASIK	24	24
24	NOIDA	76	76
25	PUNE	92	92
26	SURAT	0	0
27	TRIVANDRUM	16	16
28	VARANASI	28	28
29	VIJAYWADA	16	16
30	Grand Total	1508	1508
31	*	*	*
32	AHMEDABAD		*
33	Weekly	Target	*
34	WEEK 1	* * * * * * * * * * * *-	*
35	WEEK 2	* * * * * * * * * * * *-	*
36	WEEK 3	* * * * * * * * * * * *-	*
37	WEEK 4	* * * * * * * * * * * *-	*
38	Total	* * * * * * * * * * * *-	*
Sheet3

 

[hardeep.kanwar]

44 Views

Not a Single Reply

Hummmm

 

[jasonb75]

Maybe some better information would promt some replies.

Are we to assume that FS means monthly target? If not how does that data table relate to the question?

Using June 2011 as an example month, what is the start date for week 1?

What are the targets for each week based on the criteria?

 

[hardeep.kanwar]

Maybe some better information would promt some replies.

Are we to assume that FS means monthly target? If not how does that data table relate to the question?

Using June 2011 as an example month, what is the start date for week 1?

What are the targets for each week based on the criteria?

Thnx for the Reply

Yes, "FS" Means Monthly Target of FS (Form Sales)

Secondly, Start Date Should be 1st, for Example 1st June ,11

 

[jasonb75]

Based on that do we assume that the last week is ignored?

4 weeks would take you to 28th June, so no target for 29th or 30th?

Based on what you've said, with a little assumption to fill the blanks.

=(vloolup($K$32,$K$5:$L$29,2,0)/23)* 5 will give week 2 target
=(vloolup($K$32,$K$5:$L$29,2,0)/23)* 6 for the other weeks.