Pro rata question

[Cossie]

I am looking for a way to calculate monthly and annual pro rata so that it automatically adjusts to the current day and month and year

eg September has 30 days and on the 15th day of the month the prorata is 50%, 10th day of september is 33% etc but when it changes to october i would like it to calcualte based on 31 days etc

for the annual pro rata i am looking for the same thing so that it calcualtes in any given year the prorata of the current date.

Is a variation of networkdays the answer?

hope this makes sense and thank you

 

[sheetspread]

This?

Excel 2010
	A	B	C
1	Date	month	year
2	2/25/2019	89.29%	15.34%
3	3/9/2019	29.03%	18.63%
4	3/25/2019	80.65%	23.01%
5	5/1/2019	3.23%	33.15%
6	6/1/2019	3.33%	41.64%
7	7/7/2019	22.58%	51.51%
8	8/11/2019	35.48%	61.10%
9	9/22/2019	73.33%	72.60%
10	10/3/2019	9.68%	75.62%
11	11/5/2019	16.67%	84.66%
12	11/7/2019	23.33%	85.21%
13	11/11/2019	36.67%	86.30%
14	11/18/2019	60.00%	88.22%
15	12/17/2019	54.84%	96.16%
Sheet3

Cell Formulas
Range	Formula
B2	=DAY(A2)/DAY(EOMONTH(A2,0))
C2	=YEARFRAC(DATE(YEAR(A2),1,1)-1,A2,1)

 

[Cossie]

Thank you very much

 

[Cossie]

if i get this as the result how do i remove the training numbers and end up with 92.8%

=CONCATENATE("Pro Rata ",($K$2*100)) is my formula

Pro Rata 92.8571428571429 is what is displayed

thanks again

 

[sheetspread]

=CONCATENATE("Pro Rata ",(trunc($K$2*100,1)),"%")



you can also join strings with & instead of concatenate

 

[Cossie]

thanks very much again