R
Randy
I am attempting to create a prorate calculator of sort based on a 30 day prorate. Unfortunately I can't seem to get access to prorate on 30 days. For the months that have 31 days and February with 28 days it calculates to the exact day. I need this to calculate for 30 days no matter what. I have included what I have come up with so far. If anyone could provide any assistance or suggestions it would be greatly appreciated. Thank you for your time.
IIf(([Prorate Period To]"mm"="2"), (([Rent Amount]/30)*([prorate period to],"dd"+2)-[prorate period from]) & IIf(([Prorate Period To]"dd"="31"), (([Rent Amount]/30)*([prorate period to],“ddâ€-1)-[prorate period from]), ([Rent Amount]/30)*([prorate period to]-[prorate period from])
IIf(([Prorate Period To]"mm"="2"), (([Rent Amount]/30)*([prorate period to],"dd"+2)-[prorate period from]) & IIf(([Prorate Period To]"dd"="31"), (([Rent Amount]/30)*([prorate period to],“ddâ€-1)-[prorate period from]), ([Rent Amount]/30)*([prorate period to]-[prorate period from])