You are here:

- Home
- Computing/Technology
- Business Software
- Excel
- Tracking Monthly Money Contributions

Advertisement

Dear Richard,

Thank you very much for your advice, I'm glad to say it will work, however a small snag, it is limited to a period. Once the cycle is complete, must I start all over again?

Regards

Simon

I am not sure how the suggestion I gave you limits the solution to a period. But I am guessing that the amount that is put in is the limitation, for example if you enter 12,000 as the expected contribution and you expect 1,000 per month to be contributed then the solution is limited to 12 months.

If the above is the problem, then there are a couple of solutions.

1---The amount you enter can be much higher, for example if you entered 60,000 then the limitation would be 60 months or 5 years.

2--This suggestion will get to be a bit more complicated but maybe more useful.

I am not sure what cells I told you to use but I am going to guess that cell C4 was the cell that I asked you to put the total amount that a member would put in. So lets ask excel to calculate that amount.

first in cell F2 put in the date that the member started. Next in cell G2 put the amount per month that the member should put in. Next in cell C4 put in the following formula

=ROUNDDOWN((+NOW()-F2)/30,0)*G2+G2

The above formula calculates how much should be put in thru any particular date.

So if cell F2 is the beginning date of 7/1/13

and if cell G2 is the amount per month of 1,000,

Then the result will be 6,000.

This is because from the beginning date of 7/1/13 until todays date, NOW(), it has been 5 months (rounded down). I have assumed that the contribution is due the first day of the month so there should have been six contributions made to date, that is why the additional +G2 is at the end of the formula.

The rest of your worksheet can remain the same.

You can copy the formula

=ROUNDDOWN((+NOW()-F2)/30,0)*G2+G2

directly from this answer and paste it directly to your worksheet.

If this isn't what you are looking for let me know and I will give you some other suggestions.

Richard

Florida, USA

This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Excel

Answers by Expert:

Can assist you in most areas of Excel, have been working with it for about 15 years in many types of applications, but primarily in financial and accounting applications. I am a CPA and many client or client problems have necessitated the use of excel. I am not an expert in charting, macros, or pivot tables.

Have been working with Excel for about 20
years primarily in accounting and financial areas.**Education/Credentials**

BA, Certified Public Accountant