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

Allocate Hours Across Workdays

http://www.mrexcel.com/forum/excel-...ject-hours-over-given-period.html#post3727903

<tbody>
</tbody>

 

[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