Quarterly bills

Luigi802

Board Regular
Joined
Oct 16, 2014
Messages
80
OK SO my city bills are mailed to me quarterly, I want to create a formula that tells me how much I should have save thus far for my next quarterly bills. i.e.
Lets say my water bill is $100, I just paid it this month because it is the 3rd quarter of the year, so I should be saving for the next water bill. As of right now I should have saved roughly $22.82 (about $1.08 per day). I got this number by dividing the total bill ($100) by the number of days in this quarter (92 from Aug 1st to Nov 1st). That gave me the daily amount, then I took that # and multiplied it by the number of days starting from the beginning of this quarter (Aug 1st) to today (Aug 21st). ($1.08 per day X's 21). How can I do this automatically and continuously for every quarter thus far?
Really even if I could just have a reciprocating quarterly date i.e. it will say 11/1/16 until after that date then it will say 2/1/17, after that date passes 5/1/17 and so on
 
Last edited:
OK SO my city bills are mailed to me quarterly, I want to create a formula that tells me how much I should have save thus far for my next quarterly bills. i.e.
Lets say my water bill is $100, I just paid it this month because it is the 3rd quarter of the year, so I should be saving for the next water bill. As of right now I should have saved roughly $22.82 (about $1.08 per day). I got this number by dividing the total bill ($100) by the number of days in this quarter (92 from Aug 1st to Nov 1st). That gave me the daily amount, then I took that # and multiplied it by the number of days starting from the beginning of this quarter (Aug 1st) to today (Aug 21st). ($1.08 per day X's 21). How can I do this automatically and continuously for every quarter thus far?
Really even if I could just have a reciprocating quarterly date i.e. it will say 11/1/16 until after that date then it will say 2/1/17, after that date passes 5/1/17 and so on

So if I could just have the last part I'd be happy lol (Reciprocating date every 3 months (quarterly))
 
Upvote 0

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