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
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: