JimmieKaoss
New Member
- Joined
- Aug 6, 2014
- Messages
- 3
Excel 2007
Windows 7
I'm making a budget in Excel (and also making use of macros)
One section allows the user to enter "non-weekly" bills - bills/expenses that occur regularly but NOT on a weekly basis, for example, electricity bill which is billed (in Western Australia) every 3 months. Upon entering the bill as an expense, the (average) amount, and the frequency, the budget then gives a result of how much you would need to put aside per week in order to have the full amount saved by the time the bill comes in.
Anyway, in addition to this, I'd like to include the due date of the bill. The thing is, I only want to have to enter this one time only. After entering this information, along with the frequency of the bill, I want a formula that once this due date is reached, the formula looks at the frequency of the bill (in this case 3 months) and automatically updates the due date to the NEW due date which will be in 3 months time.
Seeing as bills differ in their billing cycles - some are 3 months, some 6, some annually, and so on, I would (I assume) use an =IF (or 2 or 3) combined with a =VLOOKUP and what not...I'm fairly confident that if someone can just help me out with the auto-updating date part that I'll be able to work the rest out.
Of course, I'm not sure how I'll exactly input the necessary information to start with in order for the formula to work, but hey, I'll work that bit out later too :P
Windows 7
I'm making a budget in Excel (and also making use of macros)
One section allows the user to enter "non-weekly" bills - bills/expenses that occur regularly but NOT on a weekly basis, for example, electricity bill which is billed (in Western Australia) every 3 months. Upon entering the bill as an expense, the (average) amount, and the frequency, the budget then gives a result of how much you would need to put aside per week in order to have the full amount saved by the time the bill comes in.
Anyway, in addition to this, I'd like to include the due date of the bill. The thing is, I only want to have to enter this one time only. After entering this information, along with the frequency of the bill, I want a formula that once this due date is reached, the formula looks at the frequency of the bill (in this case 3 months) and automatically updates the due date to the NEW due date which will be in 3 months time.
Seeing as bills differ in their billing cycles - some are 3 months, some 6, some annually, and so on, I would (I assume) use an =IF (or 2 or 3) combined with a =VLOOKUP and what not...I'm fairly confident that if someone can just help me out with the auto-updating date part that I'll be able to work the rest out.
Of course, I'm not sure how I'll exactly input the necessary information to start with in order for the formula to work, but hey, I'll work that bit out later too :P
