Calculate percentage of expected work completion any day in any month

[Xirom431]

Hi,

Depend on the month, I would like to estimate the percentage of work should be complete per day each month. Let say, 3% each day, 1 day of February is 3, next day is 6, etc. If March, it would be 2.5% first day, 5% next day, etc...

Column B contains the date of entire year, Column AT should display the %. It will reset the first day of each month.

Thanks in advance.

 

[JamesCanale]

MrExcelPlayground23.xlsx
	A	B
2	2/20/2025	71.4%
3	2/21/2025	75.0%
4	2/22/2025	78.6%
5	2/23/2025	82.1%
6	2/24/2025	85.7%
7	2/25/2025	89.3%
8	2/26/2025	92.9%
9	2/27/2025	96.4%
10	2/28/2025	100.0%
11	3/1/2025	3.2%
12	3/2/2025	6.5%
13	3/3/2025	9.7%
14	3/4/2025	12.9%
15	3/5/2025	16.1%
16	3/6/2025	19.4%
17	3/7/2025	22.6%
18	3/8/2025	25.8%
19	3/9/2025	29.0%
20	3/10/2025	32.3%
21	3/11/2025	35.5%
22	3/12/2025	38.7%
23	3/13/2025	41.9%
24	3/14/2025	45.2%
25	3/15/2025	48.4%
26	3/16/2025	51.6%
27	3/17/2025	54.8%
28	3/18/2025	58.1%
29	3/19/2025	61.3%
30	3/20/2025	64.5%
31	3/21/2025	67.7%
32	3/22/2025	71.0%
33	3/23/2025	74.2%
34	3/24/2025	77.4%
35	3/25/2025	80.6%
36	3/26/2025	83.9%
37	3/27/2025	87.1%
38	3/28/2025	90.3%
39	3/29/2025	93.5%
40	3/30/2025	96.8%
41	3/31/2025	100.0%
42	4/1/2025	3.3%
43	4/2/2025	6.7%
44	4/3/2025	10.0%
45	4/4/2025	13.3%
Sheet32

Cell Formulas
Range	Formula
B2:B45	B2	=DAY(A2)/DAY(EOMONTH(A2,0))

 

[kvsrinivasamurthy]

Only working days are to considered or weekends are also to be considered.

 

[Xirom431]

Only working days are to considered or weekends are also to be considered.

Let assume weekend is not considered

 

[JamesCanale]

MrExcelPlayground23.xlsx
	A	B	C
1		All Days	No work weekends
2	2/20/2025	71.4%	70.0%
3	2/21/2025	75.0%	75.0%
4	2/22/2025	78.6%	75.0%
5	2/23/2025	82.1%	75.0%
6	2/24/2025	85.7%	80.0%
7	2/25/2025	89.3%	85.0%
8	2/26/2025	92.9%	90.0%
9	2/27/2025	96.4%	95.0%
10	2/28/2025	100.0%	100.0%
11	3/1/2025	3.2%	0.0%
12	3/2/2025	6.5%	0.0%
13	3/3/2025	9.7%	4.8%
14	3/4/2025	12.9%	9.5%
15	3/5/2025	16.1%	14.3%
16	3/6/2025	19.4%	19.0%
17	3/7/2025	22.6%	23.8%
18	3/8/2025	25.8%	23.8%
19	3/9/2025	29.0%	23.8%
20	3/10/2025	32.3%	28.6%
21	3/11/2025	35.5%	33.3%
22	3/12/2025	38.7%	38.1%
23	3/13/2025	41.9%	42.9%
24	3/14/2025	45.2%	47.6%
25	3/15/2025	48.4%	47.6%
26	3/16/2025	51.6%	47.6%
27	3/17/2025	54.8%	52.4%
28	3/18/2025	58.1%	57.1%
29	3/19/2025	61.3%	61.9%
30	3/20/2025	64.5%	66.7%
31	3/21/2025	67.7%	71.4%
32	3/22/2025	71.0%	71.4%
33	3/23/2025	74.2%	71.4%
34	3/24/2025	77.4%	76.2%
35	3/25/2025	80.6%	81.0%
36	3/26/2025	83.9%	85.7%
37	3/27/2025	87.1%	90.5%
38	3/28/2025	90.3%	95.2%
39	3/29/2025	93.5%	95.2%
40	3/30/2025	96.8%	95.2%
41	3/31/2025	100.0%	100.0%
42	4/1/2025	3.3%	4.5%
43	4/2/2025	6.7%	9.1%
44	4/3/2025	10.0%	13.6%
45	4/4/2025	13.3%	18.2%
46	4/5/2025	16.7%	18.2%
47	4/6/2025	20.0%	18.2%
Sheet32

Cell Formulas
Range	Formula
B2:B47	B2	=DAY(A2)/DAY(EOMONTH(A2,0))
C2:C47	C2	=NETWORKDAYS.INTL(EOMONTH(A2,-1)+1,A2)/NETWORKDAYS.INTL(EOMONTH(A2,-1)+1,EOMONTH(A2,0))