Calculating the Pro Rata Factor?

[Okemn]

What is the formula to calculate the Pro Rata Factor? Basically I want to be able to take 2 dates (start date - end date) then devide by 365 and come up with the pro rata factor. Can anyone help?

 

[acw]

Hi

If you are trying to calculate the percentage of a year the number of days between the 2 dates is then

=(enddate - startdate)/365


Tony

 

[Yogi Anand]

What is the formula to calculate the Pro Rata Factor? Basically I want to be able to take 2 dates (start date - end date) then devide by 365 and come up with the pro rata factor. Can anyone help?

Hi okemn:

Welcome to MrExcel Board!

I am not sure if this is what you are looking for ...

Book1
	A	B	C	D	E
1
2		StartDate	EndDate
3		15-Feb-06	21-Dec-04	1.153
4
Sheet1

formula in cell D3 is ... =(B3-C3)/365

If I have misunderstood you rquestion, please explain a little more clearly and then let us take it from there.