Thanks:  0
Likes:  0

1. I've got a spreadsheet that lists, among other things, beginning balances, amounts to be paid, and ending balances (Beginning - paid = ending). Is there any way to make this formula occur ONLY, and automatically, on the 1st of every month without any user intervention? If I was to leave this file closed for 2 months and then open it, what would it take for it to realize 2 months have passed and process the amount paid twice?

Scott

2. Hi Scott,

If we will just use formulas in excel sheet to do this then you need a starting date/month as reference point. Say your A1 cell has this value as 01.01.2002

Now in A2 you can find the diffence of months beginning month and now with this easy formula:

=MONTH(NOW())-MONTH(A1)+1

It says (if we are in April now) 4 months and say you are increasing values by 1.15 multiplier for each month (means 15%). Now you can use B1 cell to calculate multiplier like below:

=1.15^A2

Easy? And you should care about year differences, please let me know to explain it also if you like this kind of solution.

Regards

3. Could you use something like this =IF(TODAY()>=A2,B2-C2,"") this will subtract C2 from B2 if the date in A2 is grater than or equal to today’s date, if not it will return “”, Blank.

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•