ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Need formula to add a set amount to a balance on a specific date (https://www.excelbanter.com/excel-worksheet-functions/126986-need-formula-add-set-amount-balance-specific-date.html)

Sam

Need formula to add a set amount to a balance on a specific date
 
I have a spreadsheet I am setting up to track rental properties. I would like
it to add the next month's rent to a monthly balance and showing a running
total for the year.
ie: Nov rent is 725.00, balance on Oct 31 is 250.00 for a total of $975.00
on Nov 1.

Don Guillett

Need formula to add a set amount to a balance on a specific date
 
google
excel:running balance

--
Don Guillett
SalesAid Software

"Sam" wrote in message
...
I have a spreadsheet I am setting up to track rental properties. I would
like
it to add the next month's rent to a monthly balance and showing a running
total for the year.
ie: Nov rent is 725.00, balance on Oct 31 is 250.00 for a total of $975.00
on Nov 1.





All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com