Weekly Allocation of Amount

[KevinH41]

I would like to modify solution EMT1075.

I want to provide weekly allocation amounts rather than monthly.

Appreciate any help


Here is link to file


[TABLE="width: 770"]
<tbody>[TR]
[TD="colspan: 3"]Allocate Hours Across Workdays[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 11"]http://www.mrexcel.com/forum/excel-...ject-hours-over-given-period.html#post3727903

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 4"][/TD]
[TD="colspan: 3"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[jorismoerings]

See if this helps.
Formula in D2 and copy down and across.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Start Date	End Date	Hours	2-3-2014	9-3-2014	16-3-2014	23-3-2014	30-3-2014	6-4-2014	13-4-2014	20-4-2014	27-4-2014	4-5-2014	11-5-2014
2	15-apr-14	5-5-2014	80	0	0	0	0	0	0	21	27	27	5	0
3	4-3-2014	6-jun-14	150	9	11	11	11	11	11	11	11	11	11	11
4	1-jul-14	30-sep-14	100	0	0	0	0	0	0	0	0	0	0	0
Sheet1

Cell Formulas
Range	Formula
D2	=MAX(0,NETWORKDAYS(MAX(D$1,$A2),MIN((D$1+7),$B2)))/NETWORKDAYS($A2,$B2)*$C2

 

[KevinH41]

Thanks for the help !!

Working now