| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Please help | Excel Worksheet Functions | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Count items when specific text and date criteria are met | Excel Worksheet Functions | |||
| formula for filtering and a defaulting date | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
