Excel Magic Trick 1075 Not Working

[saintpluma]

I am using excel magic trick 1075 to distribute my effort hours across given start/finish date but it isn't coming close to the effort hours needed.

 

[Eric W]

Welcome to the MrExcel forum.

Try:

Book3
	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR
9	Effort Hours	Start	Finish	Duration	12/31/2022	1/31/2023	2/28/2023	3/31/2023	4/30/2023	5/31/2023	6/30/2023	7/31/2023	8/31/2023	9/30/2023	10/31/2023	11/30/2023	12/31/2023	1/31/2024	2/29/2024	3/31/2024	4/30/2024	5/31/2024	6/30/2024	7/31/2024	8/31/2024	9/30/2024	10/31/2024	11/30/2024	12/31/2024	1/31/2025	2/28/2025	3/31/2025	4/30/2025	5/31/2025	6/30/2025	7/31/2025	8/31/2025	9/30/2025	10/31/2025	11/30/2025
10
11	19227	10/16/2023	9/4/2025	689	0	0	0	0	0	0	0	0	0	0	467.05263	856.26316	817.34211	895.1842	817.3421	817.3421	856.2632	895.1842	778.4211	895.1842	856.2632	817.3421	895.18421	817.34211	856.26316	895.1842	778.4211	817.3421	856.2632	856.2632	817.3421	895.1842	817.3421	155.6842	0	0
12	4469.42	1/1/2024	9/4/2025	612	0	0	0	0	0	0	0	0	0	0	0	0	0	234.161	213.7991	213.7991	223.98	234.161	203.6182	234.161	223.98	213.7991	234.16096	213.79913	223.98005	234.161	203.6182	213.7991	223.98	223.98	213.7991	234.161	213.7991	40.72364	0	0
13	538.33	1/1/2024	1/26/2024	25	0	0	0	0	0	0	0	0	0	0	0	0	0	538.33	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
14	269.17	2/19/2024	5/31/2024	102	0	0	0	0	0	0	0	0	0	0	0	0	0	0	32.3004	75.3676	78.95653	82.54547	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
15
Sheet5

Cell Formulas
Range	Formula
I9:AR9	I9	=EOMONTH(DATE(2022,12,31),SEQUENCE(,36,0))
H11:H14	H11	=G11-F11
I11:AR14	I11	=LET(dates,I$9:AR$9+0,hrs,E11,start,F11,finish,G11,tnd,NETWORKDAYS(start,finish),s,EOMONTH(dates,-1)+1,sd,IF(s>start,s,start),ed,IF(dates<finish,dates,finish),nd,NETWORKDAYS(sd,ed),md,IF(nd<0,0,nd),hrs*md/tnd)
Dynamic array formulas.