I have worked in excel but this is beyond my knowledge. I have a spreadsheet (someone built for me) that needs to figure the prorated amount of rent due starting the month the tenant moves in and thereafter. It also needs to be able to automatically charge a late fee of $20.00 if the rent is...