Prorate

[Guest]

Hello all...
I have created a prorate calculator of sort that will prorate someones rent
on a 30 day basis. I need the the "calculator" to prorate based on two dates
([Prorate Period From] & [Prorate Period To]). Users will input a rent amount
and the two dates. The program should then calculate a prorated rent based on
the dates entered. It should first take the rent amount and divide it by 30
(days) to find a daily rate/rent amount and then times it by the number of
days entered into the date fields. My problem is the months with 31 days and
of course February with 28 days. For instance, if a user tries to et a
prorate for February they would enter a begining date of 2/15/05 and an
ending date of 2/28/05. I need the program to see February and any months
with 31 days as if it they had 30 days no matter what. This is what I have
come up with so far and works great with the exception of February that only
allows us to put 28 days.

([Rent Amount]/30)*([prorate period to]-[prorate period from]+2)

With the 31 day month we have just been putting the 30th rather than the
31st. Would like to put the 31st and only have it count 30 days rather than
the 31st day and would ike to put the 28th (February) and have it count 30.

Any help or suggestions would be greatly appreciated.
Thank you for your time,

Randy Street
Rancho Cucamonga, CA

 

[nicolec]

Randy,

It is my understanding that prorated rent is based on 365 days in a
year, not days per month. The following should work (with the
exception of leap year, change formula to 366 days):

((rent$x12)/365)x rental period.

That's how we work out prorated rent. Hope that helps.

N

*Hello all...
I have created a prorate calculator of sort that will prorate
someones rent
on a 30 day basis. I need the the "calculator" to prorate based on
two dates
([Prorate Period From] & [Prorate Period To]). Users will input a
rent amount
and the two dates. The program should then calculate a prorated rent
based on
the dates entered. It should first take the rent amount and divide it
by 30
(days) to find a daily rate/rent amount and then times it by the
number of
days entered into the date fields. My problem is the months with 31
days and
of course February with 28 days. For instance, if a user tries to et
a
prorate for February they would enter a begining date of 2/15/05 and
an
ending date of 2/28/05. I need the program to see February and any
months
with 31 days as if it they had 30 days no matter what. This is what I
have
come up with so far and works great with the exception of February
that only
allows us to put 28 days.

([Rent Amount]/30)*([prorate period to]-[prorate period from]+2)

With the 31 day month we have just been putting the 30th rather than
the
31st. Would like to put the 31st and only have it count 30 days
rather than
the 31st day and would ike to put the 28th (February) and have it
count 30.

Any help or suggestions would be greatly appreciated.
Thank you for your time,

Randy Street
Rancho Cucamonga, CA *

 

[Guest]

Thanks Nicolec....I'll give it a shot....

Randy,

It is my understanding that prorated rent is based on 365 days in a
year, not days per month. The following should work (with the
exception of leap year, change formula to 366 days):

((rent$x12)/365)x rental period.

That's how we work out prorated rent. Hope that helps.

N

*Hello all...
I have created a prorate calculator of sort that will prorate
someones rent
on a 30 day basis. I need the the "calculator" to prorate based on
two dates
([Prorate Period From] & [Prorate Period To]). Users will input a
rent amount
and the two dates. The program should then calculate a prorated rent
based on
the dates entered. It should first take the rent amount and divide it
by 30
(days) to find a daily rate/rent amount and then times it by the
number of
days entered into the date fields. My problem is the months with 31
days and
of course February with 28 days. For instance, if a user tries to et
a
prorate for February they would enter a begining date of 2/15/05 and
an
ending date of 2/28/05. I need the program to see February and any
months
with 31 days as if it they had 30 days no matter what. This is what I
have
come up with so far and works great with the exception of February
that only
allows us to put 28 days.

([Rent Amount]/30)*([prorate period to]-[prorate period from]+2)

With the 31 day month we have just been putting the 30th rather than
the
31st. Would like to put the 31st and only have it count 30 days
rather than
the 31st day and would ike to put the 28th (February) and have it
count 30.

Any help or suggestions would be greatly appreciated.
Thank you for your time,

Randy Street
Rancho Cucamonga, CA *