FORMULAS USING DATES?

loki520

New Member
Joined
Apr 20, 2002
Messages
5
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
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,490
Messages
6,113,956
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top