Service Charge Allocation
 

Can any body write a formula to spread the services charge. For example

Annual charge is $12,000/ colum Jan to Dec monhtly 1000/- if start date is
16th Jan then Jan only 16 days and balance to go to colum Jan next year. I
use this formula:
=IF($A5<E$2,(IF($B5<E$2,0,(((IF($A5<E$2,(DAY(E$2)) ,((DAYS360($A5,E$2)+1)))/$C5*$D5))))),0).

formula works but if I take the start date as 16 Jan doesn't calculate for
16 days. Any help

Service Charge Allocation
 

Hello waseem

Should the service charge per month vary with the days in that month, e.g.
Feb charge would be less than April and April would be less than May?

It probably helps if you explain what's in cells A5:D5 and E2

"waseem" wrote:

Can any body write a formula to spread the services charge. For example

Annual charge is $12,000/ colum Jan to Dec monhtly 1000/- if start date is
16th Jan then Jan only 16 days and balance to go to colum Jan next year. I
use this formula:
=IF($A5<E$2,(IF($B5<E$2,0,(((IF($A5<E$2,(DAY(E$2)) ,((DAYS360($A5,E$2)+1)))/$C5*$D5))))),0).

formula works but if I take the start date as 16 Jan doesn't calculate for
16 days. Any help